mysql查询行转列

比如我有两张表。user和dep，一个user的zjhm对应多个dep，查询张三，证件号码对应的部门查询出来的结果为部门一，部门二

查询结果为

SELECT
    u.zjhm,
    u.name,
    GROUP_CONCAT(d.dept_name ORDER BY d.dept_name SEPARATOR ', ') AS departments
FROM
    user u
JOIN
    dep d ON u.zjhm = d.zjhm
WHERE
    u.name = '张三'
GROUP BY
    u.zjhm, u.name;