外贸网络营销的方法_中国十大品牌策划机构_如何看待百度竞价排名_行业网络营销

一、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>