查询组列表时直接显示需要的组内成员

SELECT g.id,g.name, 
(SELECT GROUP_CONCAT(c.name) FROM list AS c  
JOIN group_list gl ON c.id = gl.contact_id 
WHERE gl.contact_group_id = g.`id` ) 
AS contact_name  
FROM group AS g  
WHERE 1=1 ORDER BY g.id ASC

关键词GROUP_CONCAT