Using a Generator in PHP. Helpful when you need to work on hundreds....thousands....millions of records. Don't load them all into memory all at once. Work on them one at a time!

generator.php

<?php
$usersQuery = \App\User::query();
$usersQuery->where('type', '=', 'client');

foreach(generate($usersQuery) as $user) {
  // Do something with that user
}

helper.php

<?php 
function generate($query) {
  $sql = $query->toSql();
  $bindings = $query->getBindings();
  
  $pdo = \DB::connection()->getPdo();
  $stmt = $pdo->prepare($sql);
  $stmt->execute($bindings);
  
  while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
  	yield $row;
  }
}