mysql分组查询按照分组字段分组显示

Question

Answer 1

select group_concat(name) from table group by `group`;