How to use advanced where clause while using OR operators
Ah, you've joined the ranks of Advanced Where users -- welcome!
$user = Model:: ->where('user_id', 1) ->where('member', 'Yes') ->where(function($query) { $query ->where('cricket', 1) ->orWhere('tennis', 1); ->orWhere('football', 1); }) ->select(['id', 'user_id', 'member', 'football', 'tennis', 'cricket']) ->get();