SELECT name, GROUP_CONCAT(DISTINCT `1度` ORDER BY `1度`) AS `1度`, GROUP_CONCAT(DISTINCT `2度` ORDER BY `2度`) AS `2度` FROM 表名 GROUP BY name;