mybatis resultMap 用法

<resultMap id="PromotionDetailResultMap" type="PromotionDetailResult">
<!--ID比不可少-->
    <id property="promotionId" column="promotion_id"/>
    
    <!--PromotionDetailResult 类中要有一个 属性名为promotionTimeRangeResultList 类型 是 list ，泛型是PromotionTimeRangeResult-->
    <collection property="promotionTimeRangeResultList" javaType="list"  ofType="PromotionTimeRangeResult">
      <id property="timeRangeId" column="timeRangeId"/>
      
    </collection>
    <collection property="promotionCityBusinessRelationResultList" javaType="list" ofType="PromotionCityBusinessRelationResult">
      <id property="businessId" column="businessId"/>
      
    </collection>
  </resultMap>
  <!--活动详情-->
  <select id="detail" resultMap="PromotionDetailResultMap">
    SELECT a.promotion_id, c.id as timeRangeId, 
		d.business_id as businessId
    FROM a
      LEFT JOIN b ON a.promotion_id=b.promotion_id
      LEFT JOIN c on a.promotion_id=c.promotion_id
      LEFT JOIN d on b.business_id=d.business_id
    where a.promotion_id=#{promotionId}
  </select>