/** * Display a listing of the resource. * * @return Response */ public function listItems() { $oQuery = Category::join('users', 'users.id', '=', 'user_id')->select('categories.id as id', 'categories.name', 'categories.description', 'users.name as user_name'); $aCategories = $oQuery->paginate(10); return View::make('/category/list', array('aCategories' => $aCategories)); }