数据库字段逗号分隔关联字典表

关键字段

GROUP_CONCAT

FIND_IN_SET（字段名，参数 如 1,2,3,4）

group by

select s.id,
             s.name,
             s.sex,
             s.age,
             s.education,
           GROUP_CONCAT(j.label) AS occupation,
             ss.create_time as receivedTime,
             s.occupation,
             ifnull(sl.employee_id,0)
            
from  m_staff_info s 
inner join staff_info_sent ss    on ss.staff_id = s.open_id
left join staff_info_liked sl on sl.staff_id = s.open_id
left join t_job_list j on FIND_IN_SET(j.id,s.occupation) 

group by s.id
order by j.label