三表联查，其中查询到的对象中某一列为List

需求：三表联查，其中查询到的对象中某一列为List

直接贴代码

sql语句

主sql.

// 三表关联查询sql
 <select id="queryMemberOrderCountInfo"
            parameterType="com.jd.medicine.erp.center.domain.entity.order.ShopOrderMemberQuery"
            resultMap="OrderMemberCountResultMap">
        select
        shop_order.id as order_id,shop_order.order_status as order_status,shop_order.order_time as order_create_time,
        shop_order.modify_date as order_finish_time,shop_order_sku_activity.activity_id as activity_id,shop_order_sku.sku_id as skuIdList
        from
        shop_order,shop_order_sku_activity,shop_order_sku
        where
        shop_order.bill_code=shop_order_sku.order_bill_code and shop_order_sku.id=shop_order_sku_activity.order_sku_id
        and shop_order.corp_id=#{
   orderMemberQuery.corpId,jdbcType=BIGINT}
        and shop_order.org_id=#