Method getCategoryById

public static function getCategoryById($id)
{
    $id = (int) $id;
    if (empty(self::$categoryI[$id])) {
        $db = Factory::getDBO();
        $query = 'SELECT a.title, a.alias, a.id, a.parent_id' . ' FROM #__phocacart_categories AS a' . ' WHERE a.id = ' . (int) $id . ' ORDER BY a.ordering' . ' LIMIT 1';
        $db->setQuery($query);
        $category = $db->loadObject();
        if (!empty($category) && isset($category->id) && (int) $category->id > 0) {
            $query = 'SELECT a.title, a.alias, a.id, a.parent_id' . ' FROM #__phocacart_categories AS a' . ' WHERE a.parent_id = ' . (int) $id . ' ORDER BY a.ordering';
            //. ' LIMIT 1'; We need all subcategories
            $db->setQuery($query);
            $subcategories = $db->loadObjectList();
            if (!empty($subcategories)) {
                $category->subcategories = $subcategories;
            }
        }
        self::$categoryI[$id] = $category;
    }
    return self::$categoryI[$id];
}