CategoryController.php

    /**
     * @param $id
     * @param int $page
     * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
     */
    public function category($id, $page = 1)
    {
        $maxItems = 9;
        $skip = ($page - 1) * $maxItems;

        $category = Category::find($id);

        $categories = DB::table('categories')
            ->where('category_id', $id)
            ->skip($skip)
            ->take($maxItems)
            ->get();

        $count = DB::table('categories')
            ->where('category_id', $id)
            ->count();

        return view('category', ['id' => $id, 'category' => $category, 'categories' => $categories, 'page' => $page, 'count' => ceil($count / $maxItems)]);
    }