mysql查询用户角色_MYSQL查询用户下多个角色信息

>

select

u.id as id,

u.name as name,

u.actual_name as actualName,

u.ip_num as ipNum,

u.intime as intime,

u.department_id as departmentId,

d.name as departmentName,

r.id r_id,

r.name r_name

from

t_user as u

left join t_department as d

on u.department_id = d.id

left join t_user_role_rel as usrel

on u.id = usrel.ref_user_id

left join t_role as r

on r.id = usrel.ref_role_idu.deleted = [email protected]@DELTED_FLAG_N}AND p.name = #{param.name}

AND u.actual_name = #{param.actualName}

AND u.department_id = #{param.departmentId}