select
    act.id active_id,act.ma_name
from
    mkt_activity act
left join
    mkt_activities_school act_sch
on
    act.id = act_sch.ma_id
    {{if .school_id }}
        where
        act.del_flag = 0
        and  act_sch.school_id = '{{.school_id}}'
    {{end}}