mybatis中多表查询collection封装后分页问题解决

分页查询所有订单（订单基本信息表  订单详情表  商品表  一起查）

 //查询所有的订单  偏移量   （当前页-1）*pageSize

    List<BaseOrder> selectList(@Param("userId") Integer userId, @Param("offset")Integer offset, @Param("pageSize") Integer pageSize);

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.interestingshop.mapper.BaseOrderMapper">


    <resultMap id="orderInfoWithGoods" type="orderInfo">
        <id column="id" property="id"></id>
        <result column="amount" property="amount"/>
        <result column="buyNum" property="buyNum"/>
        <result column="id" property="baseOrderId"/>
        <result column="goodsId" property="goodsId"/>
        <association property="goods" javaType="goods" >
            <id column="gid" property="id"></id>
            <result column="goodsName" property="goodsName"/>
            <result column="fileName" property="fileName"/>
            <result column="price" property="price"/>
        </association>


    </resultMap>


    <select id="withOrderInfo" resultMap="orderInfoWithGoods">
        select
            i.*, g.*, g.id as gid
        from
            t_order_info i
        left join
            t_goods g on g.id = i.goodsId
        where
            i.baseOrderId = #{id}
    </select>

    <resultMap id="BaseOrderWithOrderInfoWithGoods" type="baseOrder">

        <id column="id" property="id"></id>

        <result column="account" property="account"/>
        <result column="orderNo" property="orderNo"/>
        <result column="userAddress" property="userAddress"/>
        <result column="amount" property="amount"/>

        <collection property="orderInfoList" ofType="orderinfo" select="withOrderInfo"  column="id">



        </collection>

    </resultMap>



    
    <select id="selectList" resultMap="BaseOrderWithOrderInfoWithGoods">
        SELECT
            b.*
        FROM
            t_base_order b
        <where>
            <if test="userId != null">
                b.userId = #{userId}
            </if>
        </where>

        limit #{offset},#{pageSize}

    </select>

</mapper>