SQL查询父类顶级与子级，删除父类顶级，子级也删除

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 = ?