java mabitis 省市区三级联动

    <select id="getCityTree" resultMap="areaInfoResult"
            parameterType="com.zq.web.domain.basedata.SysChildCity">
        select p.area_id as provinceId,p.pid as provincePid ,p.name as provinceName,
        c.area_id as cityId,c.pid as cityPid ,c.name as cityName,
        a.area_id as areaId,a.pid as areaPid ,a.name as areaName
        from zq_area p
        INNER join zq_area c on c.pid=p.area_id
        INNER JOIN zq_area a on a.pid=c.area_id
 
    </select>
    <resultMap type="com.zq.web.domain.basedata.SysChildCity" id="areaInfoResult">
        <id column="provinceId" property="areaId"/>
        <result column="provincePid" property="pid"/>
        <result column="provinceName" property="name"/>
        <collection property="childList" ofType="com.zq.web.domain.basedata.SysChildCity">
            <id column="cityId" property="areaId"/>
            <result column="cityPid" property="pid"/>
            <result column="cityName" property="name"/>
            <collection property="childList" ofType="com.zq.web.domain.basedata.SysChildCity">
                <id column="areaId" property="areaId"/>
                <result column="areaPid" property="pid"/>
                <result column="areaName" property="name"/>
            </collection>
        </collection>
    </resultMap>

package com.zq.web.domain.basedata;
 
import com.zq.common.annotation.Excel;
import lombok.Data;
 
import java.io.Serializable;
import java.util.List;
 
/**
 * @Author Lidz
 * @Description XXX
 * @Date 2022/3/17 18:06
 **/
@Data
public class SysChildCity implements Serializable {
    private static final long serialVersionUID = -95760719060350719L;
    /**
     * ID
     */
    private Integer areaId;
 
    /**
     * 父id
     */
    @Excel(name = "父id")
    private Integer pid;
 
    /**
     * 名称
     */
    @Excel(name = "名称")
    private String name;
 
    private List<SysChildCity> childList;
}