SELECT id,`name`,`level`,PID FROM (SELECT t1.*,IF( FIND_IN_SET( PID, @pids ) > 0,@pids := IF ( FIND_IN_SET( id, @pids ) <= 0, CONCAT( @pids, ',', id ), @pids ),0 ) AS ischild \ FROM ( SELECT * FROM orgtreenew ORDER BY `level`, id ) t1, ( SELECT @pids := '{org_id}' ) t2 HAVING ischild != 0 ) AS t3 "
查询子级数据
最新推荐文章于 2025-02-14 11:33:15 发布