Сортируем подразделы универсального каталога

 $sql = "SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                 FROM cms_uc_cats cat
                 LEFT JOIN cms_uc_items con ON con.category_id = cat.id AND con.published = 1
                 WHERE (cat.parent_id=$parent_id) AND cat.published = 1
                 GROUP BY cat.id";

$sql = "SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                 FROM cms_uc_cats cat
                 LEFT JOIN cms_uc_items con ON con.category_id = cat.id AND con.published = 1
                 WHERE (cat.parent_id=$parent_id) AND cat.published = 1
                 GROUP BY cat.id
                 ORDER BY cat.title ASC";