light-apiengine/sqlconfig/system_controller/system_get_org_tree.tpl

select
    sys_org.*
from
    sys_org
left join
    sys_user
on sys_user.org_id = sys_org.id
where
    sys_org.del_flag = 0
{{if ne .role_rule ""}}
    and {{.role_rule}}
{{end}}
GROUP BY sys_org.id