[HELP] Raw query of a MySQL stored procedure - Pagination?

Pseudocode

$result = new \StdClass;
$result->page = //  get current page from Request
$result->limit = $limit;
$result->totalItems = 0;
$result->items = array();

$images = DB::select('call spMultimedia(' . $id . ')'); //  you must set LIMIT $skip $limit   and hydrate collection 
$result->totalItems = // get total items 
$result->items = $images;
return $result
}

$page = current page from requrest
$perPage = 10;
$data= $this->getImages($page, $perPage);

$images = Paginator::make(
$data->items,
$data->totalItems,
$perPage
);