如何在Laravel中合并三个集合？

Question

我有3个集合：

+----------------+  +----------------+  +----------------+ 
|     Posts      |  |   PostImages   |  |   PostFiles    |
+----------------+  +----------------+  +----------------+
|   id           |  |   id           |  |   id           |
|   title        |  |   post_id      |  |   post_id      |
|   description  |  |   patch        |  |   patch        |
|   user_id      |  +----------------+  |   description  |
+----------------+                      +----------------+

Controllers:

$posts = User::find($userdata->id)->posts;

$postids = Post::where('user_id', $userdata->id)->pluck('id')->toArray();

$images = PostImage::wherein('post_id ', $postids )->get()->All();

$files = Docs::wherein('post_id', $postids )->get()->All();

是否可以在不使用循环的情况下组合这三个集合，以获得以下结构：

[post1] => [
    title => title,
    content => content,
    images => collection [
                        image1 => patch,
                        image2 => patch,
                        image3 => patch,
                        ],
    Files => [
        [0] => [
            file1 => patch,
            description1 => description
        ],
        [1] => [
            file2 => patch,
            description2 => description
        ]
    ]
],
[post2] => [
    title => title,
    content => content,
    images => collection [
                        image1 => patch,
                        image2 => patch,
                        image3 => patch,
                        ],
    Files => [
        [0] => [
            file1 => patch,
            description1 => description
        ],
        [1] => [
            file2 => patch,
            description2 => description
        ]
    ]
],

有办法吗？

Answer 1

Yes, Laravel's 'WITH' is just what you need.

Example:

In you post model add these functions.

public function images()
{
  return $this->hasMany(YouImageModel::class, 'post_id');
}

public function files()
{
 return $this->hasMany(YourFileModel::class, 'post_id');
}

So when getting post you can eager load the images.

$posts = Post::where('user_id', $userdata->id)->with(['images', 'files])->posts;

Here is the doc link