Laravel Eloquent Relationship For Multiple tables

There is 3 tables in my database: Users, Biodata, Roles.

Users and Roles are in relation with Pivot table role_user. Users have role student & employer.

I want all the users with role student also with biodata. I tried many times but couldnot find the solution. Hope you guys help me

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

try this:

$users = User::with('biodata')->whereHas('roles', function($query) {
    $query->where('name', 'student');

I have Six tables in a sequence and I want to join them with Eloquent relationships. While I am trying to do this Laravel throws an exception as Laravel accepts only one intermediate table in its relationships. Is there any possibility to join more than three tables. Here is my scenario. Tables: Countries Table: id, name

Use whereHas , which is used to where query in realtion.

$users = User::whereHas('roles', function ($query) {
    $query->where('name', '=', 'student');

When accessing Eloquent relationships as properties, the relationship data is "lazy loaded". This means the relationship data is not actually loaded until you first access the property. However, Eloquent can "eager load" relationships at the time you query the parent model. Eager loading alleviates the N + 1 query problem.

You're looking for this: $user = User::with('roles', 'biodata')->get();

Laravel 6 Eloquent Join Multiple Tables. There are the Following The simple About Laravel 6 Eloquent Join Multiple Table Full Information With Example and source code. As I will cover this Post with live Working example to develop laravel 6 left join with relationships, so the Searching multiple tables with one query with Laravel 6 is used for this example is following below.

In this example, I will create a "posts" table and "comments" table. both tables are connected with each other. now we will create one to many relationships with each other by using the laravel Eloquent Model. We will first create database migration, then model, retrieve records and then how to create records too.

I'm using Laravel and the Eloquent ORM that it provides but I'm struggling to select the data I need. I have 3 Models. House; Occupants; Job; A house can have multiple occupants and I can easily get these using the following.

The Eloquent ORM included with Laravel provides a beautiful, simple ActiveRecord implementation for working with your database. Each database table has a corresponding "Model" which is used to interact with that table. Models allow you to query for data in your tables, as well as insert new records into the table.