How to implement multicategories in news?

Question

MySQL

I am finishing the news module on the site. It is necessary to make it possible to add several categories to the news.
There are 2 tables:

The news itself

category table

Through laravel I get the following data:

public static function getNews(){
        $getNews = News::where('status_news', 1)
                        ->orderBy('id_news', 'desc')
                        ->join('users', 'author_news', '=', 'id_users')
                        ->join('category', 'id_category', '=', 'category_news')
                        ->paginate(3);

        return $getNews;
    }

But this query does not take into account multicategories. So how do you do it right? It is desirable if you do not need to change the table. Thanks in advance!

Answer 1

It seems that TAGS have long been invented as well as methods for working with them - it is better to use them.