SELECT
@parentIds,
@lev:=@lev+1,
(select @parentIds:= group_concat(id) from table_name where find_in_set(parent_id,@parentIds))
FROM
table_name,
(select @parentIds:=40,@lev:=0) b
where @parentIds is not null
mysql-纯sql方式实现父子级递归查询
最新推荐文章于 2024-08-19 16:10:28 发布