删除子类别上的现有FK约束并重新创建FK但添加ON DELETE CASCADE。

Drop your existing FK constraint on Child Categories and recreate the FK but add a ON DELETE CASCADE.