How I can do this recursive query into CCv6? Thanks.
select aid,
name,
parent_aid
from (select * from table
order by parent_aid, name) tree,
(select @pv := '$this->data("filter")') initialisation
where find_in_set(parent_aid, @pv)
and length(@pv := concat(@pv, ',', aid))
