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