树形结构语法

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;