CAllUser::GetDropDownList

static function GetDropDownList($strSqlSearch = "and ACTIVE='Y'", $strSqlOrder = "ORDER BY ID, NAME, LAST_NAME")
{
	global $DB;
	$connection = BitrixMainApplication::getConnection();
	$helper = $connection->getSqlHelper();

	$strSql = "
		SELECT
			ID as REFERENCE_ID,
			" . $helper->getConcatFunction("'['", "ID", "'] ('", "LOGIN", "') '", "coalesce(NAME,'')", "' '", "coalesce(LAST_NAME,'')") . " as REFERENCE
		FROM
			b_user
		WHERE
			1=1
		$strSqlSearch
		$strSqlOrder
		";
	$res = $DB->Query($strSql);

	return $res;
}