關聯查詢完，寫個 select 把條件放在外面，方便條件處理

select * from (

select

r.id,

r.xm,

r.jl_zr

l.bj

from user r

left school l join r.Id= l.id

)where jl_zt = '10'