mysql的多表联合查询 mybatis resultmap

#左外连接查询

</collection>
    </collection>
</resultMap>
           

select * from

t_setmeal sm

left join t_setmeal_checkgroup sc on sm.id = sc.setmeal_id

left join t_checkgroup cp on sc.checkgroup_id = cp.id

left join t_checkgroup_checkitem cc on cp.id = cc.checkgroup_id

left join t_checkitem ci on cc.checkitem_id = ci.id where sm.id=13