Iterating through result set in Laravel controller

You need to use it as an object:

$result = DB::select($query);

foreach($result as $r){
    echo $r->email;
}

Or if for some reason you want to use it as array, you need to convert it first:

$result = DB::select($query)->toArray();

foreach($result as $r){
    echo $r['email'];
}