SELECT
b1.id,
b1.phone_number,
b2.bankShortName,
b3.branchShortName,
GROUP_CONCAT(sr.name)as roleName
FROM
bank_user b1
left join
bank b2 on b1.bankId = b2.id
LEFT JOIN
bank_branch b3 on b1.branchId = b3.orgCode
left JOIN sys_user_role sur on sur.sys_user_id=b1.id
left join sys_role sr on sr.id = sur.sys_role_id
GROUP BY b1.id
b1.id,
b1.phone_number,
b2.bankShortName,
b3.branchShortName,
GROUP_CONCAT(sr.name)as roleName
FROM
bank_user b1
left join
bank b2 on b1.bankId = b2.id
LEFT JOIN
bank_branch b3 on b1.branchId = b3.orgCode
left JOIN sys_user_role sur on sur.sys_user_id=b1.id
left join sys_role sr on sr.id = sur.sys_role_id
GROUP BY b1.id