light-apiengine-feature/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 .user_id ""}}
    and sys_user.id = '{{.user_id}}'
{{end}}
GROUP BY sys_org.id