Pagination Issue

gistfile1.txt

If I add this code to my query:

->leftJoin('event_schedule', function($join) {
  $join->on('event_schedule.foreign_id', '=', 'crm_actions.id')
       ->where('event_schedule.event_id', '=', 6);
})

I receive this
array (size=7)
  'total' => int 19
  'per_page' => int 10
  'current_page' => int 1
  'last_page' => int 2
  'from' => int 1
  'to' => int 10
  'data' => 
    array (size=0)
      empty
      
You see, it gets results but it doesn't return any data.
However if I remove the where condition inside the leftJoin, it returns the data normally. Like this:

->leftJoin('event_schedule', function($join) {
  $join->on('event_schedule.foreign_id', '=', 'crm_actions.id');
})

Any ideas?