上代码

父查询

IPage<PollingPlan> selectAllContainRate(IPage<PollingPlan> page, @Param("companyId") Integer companyId, @Param("departmentId") Integer departmentId, @Param("timeType") Integer timeType);

<resultMap id="BaseResultMap" type="com.zjars.unified.device.bean.model.PollingPlan">
        <id column="id" property="id"/>
        <association property="rate" column="{id=id,timeType=timeType}" select="com.XXX.mapper.PollingTaskMapper.getRateByPlanIdAndTimeType" />
    </resultMap>

<select id="selectAllContainRate" resultMap="BaseResultMap">
        select pp.id,pp.plan_name,pp.state_check,case when (#{timeType} IS NULL) then NULL else #{timeType} end as timeType from polling_plan as pp where pp.company_id = #{companyId} and deleted = 0
        <where>
            <if test="departmentId != null">
                and pp.department_id = #{departmentId}
            </if>
        </where>
    </select>

子查询

String getRateByPlanIdAndTimeType(@Param("id") Integer id, @Param("timeType") Integer timeType);

父查询中的timeType，在父查询中创建了虚拟列，就返到子查询中了