删除前获取字段值

delete  from category where lft between @left and @right; 

delete c,a category c 
 join attachment a on c.id=a.category_id 
 where c.lft between @left and @right

DELETE FROM attachments WHERE category_id BETWEEEN @left AND @right;