mybatis从数据库中取数据且分组,返回分组数据

mapper.xml文件

    <resultMap id="WcsSzylTaskMap" type="WcsSzylTaskList">
        <id property="productionId" column="production_id"></id>
        <collection property="wcsSzylTasks"  ofType="WcsSzylTask">
        <result column="id" jdbcType="BIGINT" property="id"></result>
        <result column="production_id" jdbcType="BIGINT" property="productionId"></result>
        <result column="type" jdbcType="INTEGER" property="type"></result>
        <result column="status" jdbcType="INTEGER" property="status"></result>
        </collection>
    </resultMap>
        <select id="getList"  resultMap="WcsSzylTaskMap">

        select id, type,status,production_id
        FROM task
        where status=0 and production_id
        in (select production_id from task)
</select>

 所需对象 WcsSzylTaskList

public class WcsSzylTaskList {
    private long productionId;

    private List<WcsSzylTask> wcsSzylTasks;

    public List<WcsSzylTask> getWcsSzylTasks() {
        return wcsSzylTasks;
    }

    public void setWcsSzylTasks(List<WcsSzylTask> wcsSzylTasks) {
        this.wcsSzylTasks = wcsSzylTasks;
    }

    public long getProductionId() {
        return productionId;
    }

    public void setProductionId(long productionId) {
        this.productionId = productionId;
    }
}

 所需对象WcsSzylTask

public class WcsSzylTask {
    private long id;
    private long productionId;
    private int type;
    private int status;
    private long taskChainId;

    public long getTaskChainId() {
        return taskChainId;
    }

    public void setTaskChainId(long taskChainId) {
        this.taskChainId = taskChainId;
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public long getProductionId() {
        return productionId;
    }

    public void setProductionId(long productionId) {
        this.productionId = productionId;
    }

    public int getType() {
        return type;
    }

    public void setType(int type) {
        this.type = type;
    }

    public int getStatus() {
        return status;
    }

    public void setStatus(int status) {
        this.status = status;
    }
}