mysql查询语句拼接多部门

select
	u.id userId,
	u.name userName,
	u.account ,
	u.mobile ,
	u.email ,
	 group_concat(uo.org_id) orgIds
from
	`user` u
left join user_org uo on
	u.id = uo.user_id
	group by u.id