如何在MySQL中以多对多关系从逗号分隔列表中的一个字段连接数据？

    SELECt people.pName,GROUP_CONCAt(departments.deptName SEPARATOR ', ') deptName      FROM people LEFT JOIN people_departments         ON people.pID = people_departments.pID LEFT JOIN departments         ON people_departments.deptID = departments.deptID  GROUP BY people.pID

输出：

+-------+----------------------------------+| pName | deptName   |+-------+----------------------------------+| James | Engineering, Research || Mary  | Research, Communications         || Paul  | Engineering, Research, Marketing |+-------+----------------------------------+3 rows in set (0.00 sec)