解题
SELECT id, (CASE WHEN p_id IS NULL THEN 'Root' WHEN id IN (SELECT p_id FROM tree)THEN 'Inner' ELSE 'Leaf' END) AS TypeFROM treeORDER BY id
`单行代码`