nemovalex

$list = Category::getSortedList();
return (isset($list) && !empty($list)) ? json_encode(array_values($list)) : [];

SELECT * FROM `categories` ORDER BY COALESCE(NULLIF(parent, 0), id),
        (parent = 0) DESC,
        id