SELECT t3.* FROM ( SELECT t1.*, IF ( FIND_IN_SET( parentid, @pids ) > 0, @pids := CONCAT( @pids, ',', dictionary_id ), '0' ) AS is_child FROM dictionary AS t1, ( SELECT @pids := #{parentId} ) AS t2 ORDER BY t1.dictionary_id ASC ) t3 WHERE t3.is_child != '0' and t3.deleted = 0
树形结构查询所有子孙集sql
最新推荐文章于 2023-05-18 21:00:00 发布