使用laravel获取多个对象的关系

Question

A User has many Phones. I want to get all the phones from active users. I can do:

$phones = [];
$users = User::with('phones')->where('active', 1)->get();
foreach($users as $user) {
    $phones = array_merge($phones, $user->phones->toArray());
}
dd($phones); // <- Here are all the phones.

But I'm not sure it's the more elegant or laravel-ish way. Is there a built in magic function for such a case? Can I get all the phones from active users without writing a loop and insert in an Array?

Answer 1

You should use whereHas() method:

$phones = Phone::whereHas('user', function($q) {
    $q->where('active', 1);
})->get();