#GROUP_CONCAT 函数将查询结果行转换成逗号分隔的值
SELECT user_id, GROUP_CONCAT(user_name) AS user_names
FROM users
GROUP BY user_id;
#给转换的字段加双引号,可以使用 CONCAT 和 GROUP_CONCAT 函数
SELECT user_id, CONCAT('"', GROUP_CONCAT(user_name SEPARATOR '","'), '"') AS user_names
FROM users
GROUP BY user_id;