id_, subject_id_, classification_, code_, name_, unit_, target_memo_, sta_lat_, analyse_type_, target_level_, contrast_hx_, contrast_zx_, larger_type_, type_, target_data_source_memo_, target_calculation_, business_, memo_, sn_, flag_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT s.*, c.parent_id_ FROM sys_subject_target s LEFT JOIN sys_subject_class c ON c.id_ = s.subject_id_ where s.business_ in #{business} SELECT s.*, c.parent_id_ FROM sys_subject_target s LEFT JOIN sys_subject_class c ON c.id_ = s.subject_id_ where c.parent_id_ = #{subjectId}