Eloquent scope with join

You need to be specific about what you want to query if you want both ids

A::join(B::class, 'a.id', '=', 'b.a_id')
    ->get(['a.*', 'b.id as b_id', 'b.field1', 'b.field2']);

Well you get the idea. There is no workaround for this since MySQL works like this ;)

can I call get in a scope? and if I have a select statement, the select will be prioritised, right?

Yeah, you can call the above query in a scope. However, you need to be specific about all the selects you want to do.

Hi again,

I have tried your solution, but when I have a get on the scope and on the actual query, I get max_nesting_level exceeded error (tried increasing it from 256 to 40000, still wasn't enough, so obviously not practical). and when I omit the get from the query, the scope doesn't actually get it, it returns a builder instance.

What did work, is always selecting the B's class id and aliases it to another name to prevent conflicts. Don't feel that this is the best solution, so wondering if you have any ideas

Hi i know its a late post but I've solved a similar problem. I had solved it by the following global scope

// in boot function of your Model
static::addGlobalScope('custom_fetcher', function (Builder $builder){
    $builder->select('a.*');
    $builder->join(B::class, 'a.id', '=', 'b.a_id')
}

// later in the model
public function b()
{
     return $this->hasMany(B::class);
}

So the A model is filtered and you can retrieve the information of B via relation if needed.