light-apiengine/sqlconfig/system_controller/system_find_user_page_select.tpl

select
    sys_user.*,
    sys_org.name org_name,
    GROUP_CONCAT(sys_role.name) user_role,
    GROUP_CONCAT(sys_role.id) user_role_id
from
    sys_user
left join
    sys_org
on
    sys_user.org_id = sys_org.id
left join
    sys_user_role
on sys_user_role.user_id = sys_user.id
left join
    sys_role
on sys_role.id = sys_user_role.role_id
where
    sys_user.del_flag = 0
{{if ne .name ""}}
    and sys_user.name like '%{{.name}}%'
{{end}}
{{if ne .login_id ""}}
    and sys_user.login_id like '%{{.login_id}}%'
{{end}}
GROUP BY sys_user.id
LIMIT {{.rows}} OFFSET {{.offset}}