/** * Get all catalog data with associated categories. * * @return array */ public static function getAllWithCatagories() { $Query = $GLOBALS['Database']->query("SELECT c.*, ct.name AS catagory, sbct.name AS sub_category \n FROM " . static::$table . " AS c\n LEFT JOIN " . Category::getTable() . " AS sbct ON sbct.id = c.category_id\n LEFT JOIN " . Category::getTable() . " AS ct ON ct.id = sbct.parent_id"); return $Query->fetchAll(\PDO::FETCH_OBJ); }