mysql---group_concat

 [原数据表]

 [分组联合]

SELECT gender, GROUP_CONCAT(`name`
ORDER BY `name` DESC SEPARATOR ',') AS `names`
FROM plm_test
GROUP BY gender;

（完）