How to create such a database query in Laravel?

Question

Laravel

Good afternoon.
I have a SQL query

select * from offers where category_id = 2 and (is_active = true or is_archive = true);

Now the line that pulls the necessary data looks like this

$offers = Offer::where('category_id',$activeCat->id)->get();

How to add additional conditions without using raw queries?

Answer 1

$offers = Offer::where(function($query) {
    $query->where('is_active', true)->orWhere('is_archive', true);
})->where('category_id',$activeCat->id)->get();