MyBatis.net 一对多查询sqlmap配置

//Car 和 User 关系:一对多   

public class CarEntity : BaseEntity
    {
        public string CarId { get; set; }
        public string CarName { get; set; }

        public IList<UserEntity> UserList;
    }
    public class UserEntity : BaseEntity
    {
        public string UserId { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string Age { get; set; }
    }

//需求：对Car进行查询，同时查出对应的UserList

//注意：在使用sqlMapping映射到另一个resultMap时，一定要加上命名哪个空间，即使这个resultMap就在当前文件中也要加上

<sqlMap namespace="CarEntity" xmlns="http://ibatis.apache.org/mapping"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <resultMaps>
    <resultMap id="userInfo" Class="Demo1.UserEntity">
      <result property="UserId" column="UserId" />
      <result property="Name" column="Name" />
      <result property="Gender" column="Gender" />
      <result property="Age" column="Age" />
    </resultMap>

    <resultMap id="result" Class="Demo1.CarEntity" groupBy="CarId">
      <result property="CarId"  column="CarId" />
      <result property="CarName" column="CarName" />
      <result property="UserList" resultMapping="CarEntity.userInfo" />
    </resultMap>
  </resultMaps>

  <statements>
    <select id="getByCarId" resultMap="result">
      select 
      c.CarId,c.CarName,
      u.UserId,
      u.Name,
      u.Gender,
      u.Age
      from car c,user u
      where c.CarId="1" and u.CarId="1"
    </select>
  </statements>
</sqlMap>