原句 select user_id, user_name from income_tl; 聚合连接 select user_id, group_concat(user_name order by user_name desc separator '|') sum_string from income_tl group by user_id; 原文: tangtong1