mybatis级联查询的新写法

先定义需要查询到的字段名称，在写级联查询语句

 <sql id="Base_Column_List" >
    CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_PHONE_NUM, CUSTOMER_EMAIL, DEPART_ID, TEAM_ID, 
    DESK_NUM, STATUS, TAG, TEAM_NAME, DEPART_NAME
  </sql>
  
  <select id="queryById" resultMap="CustomerInfoMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from (
    	SELECT C.*,T.TEAM_NAME,D.DEPART_NAME FROM CUSTOMER_INFO_T C
		LEFT JOIN DEPART_INFO_T D ON C.DEPART_ID=D.DEPART_ID
		LEFT JOIN TEAM_INFO_T T ON C.TEAM_ID=T.TEAM_ID
		)
    where CUSTOMER_ID = #{customerId,jdbcType=INTEGER}
  </select>