i2-bill-erp/sqlconfig/organ_school/base_organ_school_all_select.tpl

SELECT
    sch.name,sch.organ_id,sch.id
FROM
    base_organ_school sch
{{if .user_id }}
INNER JOIN
    base_user_organ_school user_sch
ON
    sch.id= user_sch.os_id
WHERE
    sch.del_flag = 0
    and user_sch.del_flag = 0
    and onoff =98
    and user_sch.user_id = '{{.user_id}}'
{{end}}