t1表  

语句：

select type,group_concat(name) from t1 group by type

结果