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

resultMapid="baseBeanUser"type="com.aisino.guard.vo.system.TUserVoOut">

>

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 = ${@com.aisino.guard.vo.system.TUserVO@DELTED_FLAG_N}AND p.name = #{param.name}

AND u.actual_name = #{param.actualName}

AND u.department_id = #{param.departmentId}

MYSQL查询用户下多个角色信息

标签：cti   base   ebe   rop   sre   system   mys   bsp   ted

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/it-way/p/11199495.html