<?php

class Freerolls_Leaders
{
    static public function getMembers()
    {
        $db = XenForo_Application::get('db');

        return $db->fetchAll("
            SELECT user.username
                 , user.bcp_lbp
                 , user.bcp_freeroll_money_won
                 , profile.field_value AS poker_user
              FROM xf_user
            LEFT OUTER
             JOIN xf_user_field_value AS profile
               ON profile.user_id = user.user_id
              AND profile.field_id = '626c61636b5f636869705f706f6b65725f757365726e616d65'
            WHERE user.secondary_group_ids IN (2,4,5)
        ");
    }
}

foreach (Freerolls_Leaders::getMembers() as $member) {
    // print each member
}