How to make a query to the database Laravel 5.6.?

Question

Laravel

Let's say I have a "News" table, a "categories" table and an intermediate "News categories" table.
How can I make a query to get all the news for one specific category.

Answer 1

Set up relationships and do $category->news
More details here
https://laravel.com/docs/5.6/eloquent-relationship...

Answer 2

Таблица Новости примерно так. news(id, title, ...)
Таблица Категории categories(id, title)
Таблица category_news(id, category_id, news_id)

В модели Category пишешь метод news

public function news(){
      $news_ids =  $this->hasMany("\App\CategoryNews", "category_id", "id"); // тут получаешь ид всех новостей с таблицы category_news
      $ids = "";
      foreach($news_ids as $item){
            $ids .= $item->news_id . ",";
      }
      $ids = rtrim($ids, ",");
      $news = DB::select("SELECT * FROM news WHERE id IN($ids)");
      return $news;
      
}

как-то так. Попробуйте!