Tree selection sql

parent.sql

select  id,
        name,
        parent_id 
from    (select * from user_categories
         order by parent_id, id) products_sorted,
        (select @pv := '104') initialisation
where   find_in_set(parent_id, @pv)
and     length(@pv := concat(@pv, ',', id))