更换group_concat函数的分隔符

SELECT GROUP_CONCAT(nickname SEPARATOR  '|') FROM `user` group by gender;