Shopware delete all empty Categories

deleteEmptyCategories.php

<?php
    /**
     * Delete all empty Categories
     * @return int
     */
    public function deleteEmptyCategories()
    {
        $acSql = "select * from s_categories
        left join s_articles_categories_ro ro
        on ro.categoryID = s_categories.id
        left join s_categories_attributes attr on attr.categoryID = s_categories.id
        where ro.id IS NULL
        and s_categories.parent is not null
        and s_categories.blog=false";
        $categoryIds = Shopware()->Db()->fetchAll($acSql);

        foreach ($categoryIds as $catId) {
            try {
                $this->getShopwareCategoryResource()->delete($catId['categoryID']);
            } catch (\Exception $e) {
                //do nothing
            }
        }

        return count($categoryIds);
    }