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