I want to create a single query that will fetch all Events that fall between dates.
I also want to get all their child EventImages.
Can I get all of this into a single query?
Event Model
public function eventImages()
{
return $this->hasMany(EventImage::class, 'event_id');
}
Event Images Model
public function event()
{
return $this->belongsTo(Event::class);
}
Sample Query for getting Events between dates
$events = Event::whereBetween('date', [$start_date, $end_date])
->orderBy('date', 'ASC')
->get();
Thank you!