SELECT * FROM item
CONNECT BY parent = PRIOR id
START WITH id = 0