表数据多级删除

use shop;
# 删除第三级
DELETE FROM category WHERE parent_id IN (
	SELECT category_id FROM (
	SELECT b.category_id  FROM category b
	INNER JOIN category c ON b.parent_id = c.category_id 
	AND c.name IN ( '生活服务' ) 
	) temp 
);

# 删除第二级
delete FROM category where parent_id in (
select category_id from (
SELECT category_id FROM category
where name IN ( '生活服务' ) ) temp);

# 删除第一级
delete FROM category where name IN ( '生活服务');