Optimizing MySQL Queries: Sorting Rows Based on Multiple Conditions in an Irregular Order with Laravel's Query Builder

How to Use Laravel Fluent Query API to Count Columns and Apply Where Conditions by User ID