Level 47
Yes. What I suggest is get as many cases as you'll need eager loaded. Maybe all, maybe just for the month.
Then with the eloquent collection that's returned manipulate it as you need. This will reduce your queries and is efficient.
I like using laravels collect() for this type of issue. Set each collection to its own variable so you still have the original.
Look at collections in the docs.