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

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