Laravel 7 Eloquent models, get records based on user_id in parent table (to check if it matches with Auth::id)

what are your tables called?

What are your models called?

What relationships have you created in your models?

I'll keep it to the relevant tables, models, and relationships otherwise it might be much. Since it's just the where that I can't seem to do on the parent table:

Tables:

Schema::create('opportunities', function (Blueprint $table) {
            $table->id();
            $table->foreignId('business_developer_id');
			...
			$table->foreign('business_developer_id')->references('id')->on('business_developers')->onDelete('cascade')->onUpdate('cascade');

Schema::create('business_developers', function (Blueprint $table) {
            $table->id();
            $table->foreignId('user_id');
			...
			$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade');

Schema::create('users', function (Blueprint $table) {
            $table->id();
			...

Models:

class Opportunity extends Model
{
    public function businessDeveloper()
    {
        return $this->belongsTo('App\BusinessDeveloper')->withDefault();
    }
}

class BusinessDeveloper extends Model
{
    public function user()
    {
        return $this->belongsTo('App\User')->withDefault();
    }

    public function opportunities()
    {
        return $this->hasMany('App\Opportunity');
    }
}

class User extends Authenticatable
{
public function businessDevelopers()
    {
        return $this->hasMany('App\BusinessDeveloper');
    }
}

Will this do?

In your with statement, you mention the relationship names not the table and column names,

user has many business developers and business developer has many oportunities

So, what (in words) are you trying to get?

I got someone to help me with a working solution. I was trying to get "all opportunities from the logged-in business developer" On the opportunity there is a FK to the business developer that the opportunity belongs to. Business developer has a FK to the users table. user table is even irrelevant since I check Auth::id with user_id from the business developers table. My apologies for the bad explaination. I think this solution will make it clear what i was trying to do:

public function qryOpportunities()
{
    $opportunities = Opportunity::whereHas('businessDeveloper', function($q) {
        $q->where('user_id', Auth::id());
    })
    ->with('businessDeveloper.user', 'consultantOpportunity.consultant.user', 'contactPerson', 'customer', 'headOfDepartment.user')
    ->get();
    return $opportunities;
}

but WHY? does user have MANY business developers

public function businessDevelopers()
    {
        return $this->hasMany('App\BusinessDeveloper');
    }

You're totally right. I never gave it a second thought since I didn't design the database. It's a school project. I can't come up with a reason. Should be one on one relationship. Thanks for pointing that out.