>
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]_FLAG_N}AND p.name = #{param.name}
AND u.actual_name = #{param.actualName}
AND u.department_id = #{param.departmentId}