with subqry(CODE,NAME,PCODE) as (
  select CODE,NAME,PCODE from Category where CODE = 'fa3e09f7-1db7-4fa2-92a4-106e35e136ea'
  union all
  select Category.CODE,Category.NAME,Category.PCODE from Category,subqry
  where Category.PCODE = subqry.CODE
  )
  select * from subqry;