mysql中用逗号分割的id取名称的方法

直接上SQL代码

        select
            p.task_ids,
            GROUP_CONCAT(DISTINCT t.name) as task_names,
						p.reviewer_ids,
            GROUP_CONCAT(DISTINCT u1.user_name) as reviewer_names
        from
            pmc_journal p
            left join pmc_plus_task t ON FIND_IN_SET(t.UID, p.task_ids) > 0
            left join sys_user u1 ON FIND_IN_SET(u1.user_id, p.reviewer_ids) > 0
        where p.id = '1'