with recursive r as(
  select id, out, res, tier, qty, 0 as lvl 
  from schema_info 
  where out = 78 
  union all
  select i.id, i.out, i.res,  i.tier, i.qty, r.lvl + 1 as lvl
  from r join schema_info i on i.out=r.res
  where r.out <> r.res
) 
select * from r