MySql多表关联查询，即 多left join

业务场景 
1、examine表和examine_resource表关联
2、examine表和examine_user表关联
3、examine_user表和examine_user_resource表关联
sql实现：
select
    a.id as id,
    a.them as them,
    a.time as time,
    a.createUser as createUser,
    a.status as status,
    a.examineResourceId as examineResourceId,
    a.result as result,
    eur.resource_id as examineUserResourceId
from
(
    select
        e.id as id,
        e.theme as them,
        e.theme as time,
        e.create_user as createUser,
        e.status as status,
        er.resource_id as examineResourceId,
        eu.result as result,
        eu.id as examineUserId
    from
        examine e LEFT JOIN examine_resource er on e.id = er.examine_id
        LEFT JOIN examine_user eu on e.id = eu.examine_id
    where
    eu.job_no = #{jobNo}
) a
LEFT JOIN examine_user_resource eur ON a.examineUserId = eur.examine_user_id