直接这个sql就可以
在finedb表
SELECT * FROM (
select
u.ID 用户ID,
u.USERNAME ,
u.REALNAME 姓名,
rc.id 角色ID,
rc.NAME 角色 ,
rd.id 部门ID,
d.NAME 部门
from FINE_USER u
left join FINE_USER_ROLE_MIDDLE rm on u.id=rm.userId
left join FINE_CUSTOM_ROLE rc on rm.ROLETYPE=2 and rm.ROLEID=rc.id
left join FINE_DEP_ROLE rd on rm.ROLETYPE=1 and rm.ROLEID=rd.id
left join FINE_DEPARTMENT d on d.id=rd.DEPARTMENTID
left join FINE_POST p on p.id=rd.POSTID
where 1=1 ${if(len(fine_username) == 0,"","and u.USERNAME ='"+fine_username+"' ") }
) A
1min目标场景问卷
立即参与
