Laravel query using whereHas

On the color class: relation

public function color()
{
    return $this->hasOne(Colors::class)->latest();
}

So a Color has a car_id column? How is this not a belongsToMany relationship?

Yes. Relation color->car:

public function cars()
{
      return $this->belongsTo(Cars::class);
}

But i need get only last row, and whereIn on this row

Okay 🤷‍♂️

In that case, you need to have a read of this excellent article by Jonathan Reinink which wxplains (at the end) why your current approach will not work.

In your case, the current color would be the following:

public function color()
{
	return $this->belongsTo(Color::class);
}

public function scopeWithColor($query)
{
	$query->addSelect(['color_id' => Color::select('id')
		->whereColumn('car_id', 'cars.id')
		->latest()
		->take(1)
	]);
}

This approach inverts the relationship, placing a pseudo-column on Car (color_id) and a BelongsTo relationship on the Car class. Now, you query will be:

$colors = ['black', 'white'];
$cars->whereHas('color', function($builder) use ($colors) {
          return $builder->whereIn('paint_color', $colors);
});

Model color have car_id attribute (its like relatationship table), but car haven't color_id

Read my post...

This approach inverts the relationship, placing a pseudo-column on Car (color_id) and a BelongsTo relationship on the Car class.

But i have error Undefined column: 7 ERROR: column cars color_id

I have many cars and many colors at the db, i use pagination at the last step $cars->paginate(10)->appends(....);

I thought you might read the article I shared, and would understand that you must use the query scope to dynamically add the color_id column to the Car model.:

$cars = Car::withColor()->whereHas('color', function($builder) use ($colors) {
          return $builder->whereIn('paint_color', $colors);
})->get();

Yes, i read that

$cars = Car::query();
............
............
if($colors) {
	$cars = $cars->withColor()->whereHas('color', function($builder) use ($colors) {
          return $builder->whereIn('paint_color', $colors);
	});
}
$cars->paginate(10)->appends(....);

And what is the issue, it should be different to the missing color_id property at the very least?

Undefined column: 7 ERROR: column cars color_id at >whereHas('color'

That should not be that case if you have used the withColor scope; clearly this scope adds a color_id colum/property to the Car model.

But i have error, i use this code

$cars = Car::query();
............
............
if($colors) {
	$cars = $cars->withColor()->whereHas('color', function($builder) use ($colors) {
          return $builder->whereIn('paint_color', $colors);
	});
}
$cars->paginate(10)->appends(....);