Exemplo para fazer o inverso:
with RECURSIVE parents (id, parent_id, name) as (
select id, parent_id, name from users
where id = 5
union all
select u.id, u.parent_id, u.name from users as u
inner join parents on u.id = parents.parent_id
)
select * from parents
--SIGA ME NAS REDES SOCIAIS --
https://steemit.com/@emtudo
https://busy.org/@emtudo
https://d.tube/c/emtudo
skype: emtudo
twitter - twitter.com/emtudo
linkedin: / emtudo
facebook: https://fb.com/emtudocasts
telegram @emtudo
/ emtudo
github.com/emtudo
gitlab.com/emtudo
bitbucket.com/emtudo
medium.com/@emtudo
https://emtudo.dev