How to add pagination to a complex query in Laravel?

Question

Laravel

There is such a request in Laravel:

Topic::join('blogs', 'topics.blog_id', '=', 'blogs.id')
         ->join('blog_subscriptions as us', function ($j) use ($userId) {
            $j->on('us.blog_id', '=', 'blogs.id')
              ->where('us.user_id', '=', $userId);
          })->get(['topics.*']);

It pulls out all topics from blogs to which the User is subscribed.
How to apply pagination to it? Just in case, I'm attaching the DB schema.

Answer 1

First create relations laravel.com/docs/4.2/eloquent#relationships for the User and Blog model, and then human request

User::find(1)->blogs()->with('topics')->paginate(10)