light-apiengine/sqlconfig/system_controller/system_find_user_page_select.tpl

select
    sys_user.*,
    sys_org.name org_name
from
    sys_user
left join
    sys_org
on
    sys_user.org_id = sys_org.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}}
LIMIT {{.rows}} OFFSET {{.offset}}