light-apiengine/sqlconfig/system_controller/system_get_menu_tree.tpl

{{if ne .user_id ""}}
select
    menu.*
from
    sys_menu
    JOIN sys_role_menu
    JOIN sys_user_role
    JOIN sys_user
    LEFT JOIN sys_menu menu
    ON FIND_IN_SET(menu.id, REPLACE(sys_menu.inheritance, '|', ','))
where
    sys_menu.id = sys_role_menu.menu_id
    and sys_role_menu.role_id = sys_user_role.role_id
    and sys_user_role.user_id = sys_user.id
    and sys_menu.del_flag = 0
    and sys_user.id = '{{.user_id}}'
{{if ne .name ""}}
    and sys_menu.name like '%{{.name}}%'
{{end}}
{{if ne .type_op ""}}
    and sys_menu.type {{.type_op }} {{.type}}
{{end}}
GROUP BY menu.id
order by menu.order_num
{{else}}
select
    distinct sys_menu.*
from
    sys_menu
where
    sys_menu.del_flag = 0
{{if ne .name ""}}
    and sys_menu.name like '%{{.name}}%'
{{end}}
{{if ne .type_op ""}}
    and sys_menu.type {{.type_op }} {{.type}}
{{end}}
order by sys_menu.order_num
{{end}}