mybatis 多表查询的wapper

service写法

	QueryWrapper<DriverBaseVO> wrapper = new QueryWrapper<>();

    wrapper.eq(StringUtil.isNotBlank(query.getIsDdOrder()),"a.is_dd_order",query.getIsDdOrder());
	wrapper.eq(StringUtil.isNoneBlank(query.getCityId()),"a.city_id",query.getCityId());
	wrapper.eq(StringUtil.isNoneBlank(query.getGroupOrgId()),"a.group_org_id",query.getGroupOrgId());
	wrapper.like(StringUtil.isNoneBlank(query.getDriverId()),"a.driver_id",query.getDriverId());
	wrapper.eq(StringUtil.isNoneBlank(query.getUSource()),"a.u_source",query.getUSource());
	wrapper.like(StringUtil.isNoneBlank(query.getName()),"a.name",query.getName());
	wrapper.eq(StringUtil.isNoneBlank(query.getStatus()),"b.status",query.getStatus());
	wrapper.like(StringUtil.isNoneBlank(query.getCarLeader()),"c.captain_name",query.getCarLeader());
	//加入数据权限


	wrapper.and(w -> w.in("a.group_org_id", AuthUtil.getUser().getOrgChildIds())
		.or().eq("a.city_id",AuthUtil.getUser().getCity()));


	IPage<DriverBaseVO> driverPage = baseMapper.selectDBPage(PageDTO.of(query.getCurrent(), query.getSize()), wrapper);
	if (driverPage.getRecords().isEmpty()){
		return driverPage;
	}

mapper接口写法

/**
 * 分页
 * @param page
 * @param wrapper
 * @return
 */
IPage<DriverBaseVO> selectDBPage(Page<DriverBaseVO> page, @Param("ew") QueryWrapper<DriverBaseVO> wrapper);

xml 写法

<select id="selectDBPage" resultType="org.shopecsystem.driver.vo.DriverBaseVO">
    SELECT
        a.driver_id,a.u_source,a.`name`,a.tel,a.id_no,a.group_org_id,a.city_id,b.status,c.captain_name,c.captain_phone
    FROM
        `driver_base` a
            LEFT JOIN driver_biz b ON a.driver_id = b.driver_id
            left join amc_fleet c on b.fleet_id = c.id
    where
        a.deleted = 0
    <if test="ew.sqlSegment != '' and ew.sqlSegment != null">
        and ${ew.sqlSegment}
    </if>
    ORDER BY a.create_time desc
</select>