Counting Records from Another Table as a Name in Laravel Eloquent Using DB::raw()

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