How to get data in eloquent where we have companies , users that belong to the companies and the users have profiles?

To retrieve a company with its users and the profiles of those users, you can use Eloquent's eager loading feature. This allows you to load all the related data in a single query, reducing the number of queries to the database.

Here's how you can achieve this:

// Retrieve a specific company by its id with users and their profiles
$companyId = 1; // Replace with the actual company id you want to query
$company = Company::with('users.profile')->find($companyId);

// If you want to retrieve all companies with their users and profiles
$companies = Company::with('users.profile')->get();

This will give you a collection of companies, each with their related users and the users' profiles loaded. You can then iterate over the collection and access the data as needed:

foreach ($companies as $company) {
    echo "Company: " . $company->name . "\n";
    foreach ($company->users as $user) {
        echo "User: " . $user->name . "\n";
        if ($user->profile) {
            echo "Profile: " . $user->profile->bio . "\n"; // Assuming 'bio' is a field in the profile
        }
    }
}

Make sure that your User and Profile models are set up correctly to allow for this relationship:

// User model
class User extends Authenticatable
{
    // ...

    public function profile()
    {
        return $this->hasOne(Profile::class, 'user_id');
    }

    public function companies()
    {
        return $this->belongsToMany(Company::class);
    }

    // ...
}

// Profile model
class Profile extends Model
{
    // ...

    public function user()
    {
        return $this->belongsTo(User::class);
    }

    // ...
}

Remember to replace 'user_id' with the actual foreign key if it's different in your database schema. Also, replace 'bio' with the actual field you want to access from the Profile model.