Support the ongoing development of Laravel.io →
emissar
posted 9 years ago
Database Eloquent
Last updated 2 years ago.
0
emissar
replied 9 years ago
Solution

I found solution:

 $ids = $data->cities->lists('id');
            $users = User::with('city')
                    ->leftJoin('city_user', 'city_user.user_id', '=', 'users.id')
                    ->whereIn('city_user.city_id', $ids)
                    ->paginate(config('cfg.onpage'));
0

Sign in to participate in this thread!

Eventy

Your banner here too?

emissar emissar Joined 7 Jul 2015

Moderators

We'd like to thank these amazing companies for supporting us

Eventy
Fathom
Forge
Envoyer
Beyond Code
BairesDev
N-iX
Litslink

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X (Twitter) Bluesky Bluesky GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2025 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise