关联查询完，写个 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'