// User Modelclass User extends Model{ protected $connection = 'conn_1'; public function posts() { return $this->hasMany(Post::class); }} // Post Modelclass Post extends Model{ protected $connection = 'conn_2'; public function user() { return $this->belongsTo(User::class, 'user_id'); }} // wherehas()$posts = Post::whereHas('user', function ($query) use ($request) { $query->from('db_name_conn_1.users')->where(...); })->get();
Tip given by @adityaricki
Enjoyed This Tip?
Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.
Recent Courses
[NEW] Building a Typical Laravel SaaS
8 lessons
55 min
How to Build Laravel 12 API From Scratch
28 lessons
1 h 21 min
Laravel HTTP Client and 3rd-Party APIs
7 lessons
50 min