一、mapper层
List<Long> selectListById(@Param "grpId") String grpId);
二、xml层
<select id="selectListById" resultType="java.lang.Long">WITH RECURSIVE subordinates AS (SELECT id,str01,tenant_idFROM cloud_base_personWHERE str01 = #{grpId}UNION ALLSELECT t.id, t.str01, t.tenant_idFROM cloud_base_persontINNER JOIN subordinates s ON t.str01 = s.idWHERE t.deleted != '1' AND t.tenant_id = s.tenant_id)SELECT id FROM subordinates;
</select>