i am not doing the work/homework for you.. its a join/related query.. try it in the MySQL console and then go from there, if you get stuck on the query then post the query here..
or alternatively use relationship aspect of laravel to link categories/products and then construct a proper eloquent query using with() construct.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast