将多个参数拼接成一个字符串
CONCAT(str1,str2,.....)
使用指定分隔符拼接字符串
CONCAT_WS(separator str1,str2,.....)
将同一列 多行的值拼接成字符串
select
GROUP_CONCAT(m.auth SEPARATOR '@') auths
from
s_menu m
INNER JOIN role_menu rm on m.id=rm.menuId
INNER JOIN s_user_role ur on rm.roleId = ur.roleId
and ur.userId = 1
where
m.category = 3
and m.isdel = 0
and m.status = 1