Laravel Eloquent“With”过滤器

Question

Let's say I have the following setup. A User has many Coments. In my REST API I have an action /users where I display all the users and their comments.

I would do that like this:

return Response::json(User::with('comments')->get(), 200);

But now I only want to display a User in that list if it has at least one Comment. Something in the lines of:

return Response::json(User::with('comments')->whereCount('users.comments', '>', 0)->get(), 200);

But that obviously does not work. What is the correct way to do this in conjunction with the with method?

Answer 1

You can use in this case has to get only users that has at least one comment:

return Response::json(User::with('comments')->has('comments')->get(), 200);

Reference