三级分类用sql语句怎么写（多级分类的写法）

SELECT * 
from cate a
LEFT JOIN cate b on b.pid = a.id
LEFT JOIN cate c on c.pid = b.id
where a.pid =0