How to correctly move a function to a model in Laravel?

Question

Laravel

I have the following function call in the controller to get the latest topics.

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.*']);

How can I correctly transfer it to the Model, so that then I can simply call it with a function
Topic::getSubscribedTopics($userId);

Answer 1

Implement via the "Repository" pattern and store similar constructs in the repository without cluttering the model and controller. This is business logic and it would be nice to separate it from the application.