@GoldeNx3 Instead of having a separate values table, add a value column on your attribute–offer pivot table:

$table->primary(['attribute_id', 'offer_id', 'value']);
$table->unsignedInteger('attribute_id');
$table->unsignedInteger('offer_id');
$table->string('value');
$table->i

You can then load attributes and their values from a relation on your Offer model:

class Offer extends Model
{
    public function attributes()
    {
        return $this->belongsToMany(Attribute::class)->withPivot('value');
    }
}

<dl>
    @foreach($offer->attributes as $attribute)
        <dt>{{ $attribute->name }}</dt>
        <dd>{{ $attribute->pivot->value }}</dd>
    @endforeach
</dl>

Okay, but now I can assign only one value to attribute (Because there is error while I'm adding another record to attribute_offer with the same attribute_id and offer_id)

I removed primary keys on attribute_id and offer_id and assign primary key on ID, then I can add more record.

While I have 2 records in attribute_offer (One is value Blue, second is Red), output look like this:

Color: Blue, Color: Red. How to do, to output word "Color" only once, to make smthg like that:

Color: Blue, Red.

@GoldeNx3 Yeah, you’d want the primary key over all three columns. An offer should be able to have the same attribute multiple times, but each instance to have a different value.

I think it is solution for my problem. But one last question. If cars have three different colors: blue, red, green. How to make query to get all cars, that have color green and red?

@GoldeNx3 You might want to look into something like Algolia if you want to search products based on facets like that.

@martinbean Got it! But one last question.

While I do

@foreach($offer->attributes as $attribute) {{ $attribute->name }} {{ $attribute->pivot->value }} @endforeach

This function return me all of the attributes from database. How to get control which attribute is it? Something like array where I can store all attributes for offer, and then output like that:

echo $offerAttributes['Color'];

And this will output all colors from database.