SQL一对多关系的，多合并显示 GROUP_CONCAT

1. 两个表
   
   
   两个表时
   select name as ‘歌手’,(select GROUP_CONCAT(name,’’) from song where song.person_id = person
   .id) as ‘歌曲’ from person;

2. 一个表时
   
   select p as ‘歌手’, GROUP_CONCAT(song) as ‘歌曲’ from p_song GROUP BY p;