Как мне выводить статьи с категорией, тегами имея такие таблицы?

Question

[javanub]

Post table

+----+---------+-----------------+
| id |  title  |      text       |
+----+---------+-----------------+
|  1 | Title 1 | This is example |
|  2 | Title 2 | This is example |
|  3 | Title 3 | This is example |
+----+---------+-----------------+

Tags table

+----+--------+
| id |  tag   |
+----+--------+
|  1 | jQuery |
|  2 | PHP    |
|  3 | Stack  |
+----+--------+

Category table

+----+------------+
| id |  category  |
+----+------------+
|  1 | Category 1 |
|  2 | Category 2 |
|  3 | Category 3 |
+----+------------+

Post tags relation table (аналогично с category)

+---------+--------+
| post_id | tag_id |
+---------+--------+
|       1 |      1 |
|       1 |      2 |
|       2 |      3 |
+---------+--------+

Я хотел бы получить такой результат, как мне это сделать?

+---------+------------------+--------------------+------------+
|  Title  |       Text       |        Tag        | Category |
+---------+------------------+--------------------+------------+
| Title 1 | This is example  | jQuery, PHP        | Category 2 |
| Title 2 | This is example  | Stack              | Category 1 |
| Title 3 | This is example  | jQuery, PHP, Stack | Category 1 |
+---------+------------------+--------------------+------------+

Answer 1

[javanub]

Решил
dd(\App\Post::with('category', 'tag')->get());

Comments

[JhaoDa]

Неужели документацию прочитал?