mybatis 根据子类获取父类的方法 base_type_detail是数据库里面的表

mybatis 根据子类获取父类的方法 base_type_detail是数据库里面的表

<select id="getTypeDetailByChild" resultType="BaseTypeDetailVO">

    SELECT T2.id, T2.NAME,T2.PARENT_ID,T2.TYPE_ID
    FROM (  
        SELECT  
            @r AS _id,  
            (SELECT @r := parent_id FROM base_type_detail WHERE id = _id) AS parent_id,  
            @l := @l + 1 AS lvl  
        FROM  
            (SELECT @r := #{childId}, @l := 0) vars,  
            base_type_detail h  
        WHERE @r &lt;> 0) T1  
    JOIN base_type_detail T2  
    ON T1._id = T2.id  
    ORDER BY T1.lvl DESC
</select>