查询分组条件之外的值,拼接成字符串(group_concat) select theme_id, group_concat(dest_id) dest_id, group_concat(dest_name) dest_name from strategy group by theme_id