A表大致结构:
id name pid
1 顶级1 0
2 顶级2 0
3 子级1 1
4 子级2 1
5 子级1 2
.................................................更多
查询的SQL:
SELECT a.id.a.name,( SELECT b.`name` FROM A AS b WHERE b.id = a.pid) AS ParentName
FROM A AS a
删除父类,子类对应删除SQL:
DELETE
FROM A
WHERE id = ? OR pid = ?