Mysql查询把多列返回结果集拼接成一个字符串代码结果代码SELECT u.id, u.NAME, r.NAME AS roleName, GROUP_CONCAT(m.NAME) AS merchName, u.stateFROM tbl_user uLEFT JOIN tbl_user_park up ON u.id = up.useridLEFT JOIN tbl_merch m ON up