Laravel选择对象作为属性

Question

I'd like to know if it is possible to do a left join in a query and if it exists instead of having all the columns in the same "level" make the joined table go as a property (This without any relationships)

For example

$users = user::leftJoin("posts","users.id","=","posts.user_id")->get();

Instead of returning every field together,

["id"/*This actually gets messed up if select doesn't choose wich to use*/,
  "name",
  "age",
  /*Now post fields*/
  "tile",
  "date_posted"
  ...
]

and having it return

["id",
  "name",
  "age",
  "post"=>[
    "id",
    "tile",
    "date_posted"
    ...
   ]
]

Edit: If possible to avoid loops for obvious reasons... I know it is possible and in last resort will use them but not using loops would help out alot

Answer 1

You're using eloquent for the users table. Why not use relationships? It does exactly what you want. Create a new Post model. Then add the following relationship to your User model.

public function posts()
{
    return $this->hasMany(Post::class);
}

You can now fetch the users with post like so

$users = User::with('posts')->get();

The result is exactly what you want. Also I've used User in my example, where as you've used user. The result would contain the posts object as posts instead of post as you've shown in the example, you can change this property name by changing the relationship method name. I've used these since they're the right convention.