利用GROUP

SELECT a.*,GROUP_CONCAT(b.pri_name) FROM sh_role a LEFT JOIN sh_privilege b ON FIND_IN_SET(b.id,a.pri_id_list) GROUP BY a.id;

 

 

转载于:https://www.cnblogs.com/hgj123/p/4386483.html