count

<?

foreach ($userIdsChunks as $key => $userIdsChunk) {
    $userTotals = array_merge(
        $userTotals,
        $ctrl->READ
            ->from('records')
            ->where_in('userid', $userIdsChunk)
            ->where_in('video_id', $videoIds)
            ->group_by('userid')
            ->select('userid, count(*) as total')
            ->get()
            ->result_array()
    );
}