How to get title from another table using table pivot?

Question

Laravel

Hello.
There are three tables:
post:
id
title
categories:
id
title
category_post - pivot table:
category_id
post_id
Please tell me how to get the title from the categories table that belongs to the post.
From the pivot table, we managed to get the category_id, but this is a number, but the category title is needed.
Thank you all in advance

Answer 1

You need to set the correct relays in the models. You should not touch the intermediate table at all, only Laravel needs it, but not you.
Look, for example, I have a blog post with tags, I installed such a relay:

class BlogPost extends Model
{
  ...
  public function tags()
  {
      return $this->belongsToMany('App\BlogTag', 'blog_post_tags');
  }
  ...
}

And now I can do this:

foreach($post->tags as $tag)
{
    echo $tag->name;
}