Review this Laravel Eloquent query that is causing a "N+1" performance issue. Suggest how to use eager loading (with/load) and select only required columns to reduce memory usage and database load. Explain the impact on performance.