Advance Eloquent Query for Ecommerce

https://postimg.org/image/y4d4rpeqt/ Please have a look at above image link I just want to do the eloquent query to get result like that and also i want to do filtering according to that.

Any Help Appreciated