$p = new Product(); $p->order_by(category_id); $p->get(); foreach($p as $product) { $product->category->get(); echo $product->category->name . " " . $product->name . "<br />" }