Laravel Eloquent Connect two tables set condition in last row of second table if this condition true than it will return in my array

I have two tables one is order and second is order_status. Order table has details of order. Order Status has Order's Status with timestamp when it will changed.

Order table

order_status table

I mean that order has multiple status in order_status.

I want to filter my order list table by order status.

If i want orders which are delivered (all orders whose last status is delivered) How can i achieve that?

I am using laravel 5.8 Eloquent.

via Chebli Mohamed