This is just an example pgSQL query. I don't have the exact schema right now, but basically, there was a tag (stored in table tags) which was mapping to parent (using parent_id) tag from the same table. Give a :startingTagId, this query returns a tag and all parents.

pgsql_recursive_query_example.sql

with recursive all_tags(rownum, id) as (
  select  1::bigint, id, parent_id from tags where id = :startingTagId
  union all
    select rownum + 1, c.id, c.parent_id
    from all_tags a
    inner join tags c on a.parent_id = c.id)
 select * from all_tags