group_concat()函数
实例:
CREATE TABLE `user` (
`id` bigint(22) NOT NULL AUTO_INCREMENT,
`uid` bigint(22) NOT NULL COMMENT '用户id',
`name` varchar(255) NOT NULL COMMENT '用户姓名',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6237 DEFAULT CHARSET=utf8mb4 COMMENT='';
SELECT id,uid,GROUP_CONCAT(`name` SEPARATOR ',') `name` FROM user GROUP BY uid