因此，我试图基于使用AJAX的表单的一些输入，对“成员”进行查询。

问题是，在搜索“角色”时，我得到了预期的结果。但是，一旦我尝试寻找其他元值，返回就会将DB中的所有成员都带来。

我尝试了很多方法，但我要么得到了我刚才说的结果，要么根本没有结果（即使是扮演这个角色）

这是我的PHP代码，在\'functions.php\':

function my_ajax_filter_search_callback() {
    header("Content-Type: application/json");

    if(isset($_GET[\'name\']) && !empty($_GET[\'name\'])) {
        $name = sanitize_text_field( $_GET[\'name\'] );
        $searchName = array(
            \'search\' => $name,
            \'search_columns\' => array( \'first_name\' ),
            \'compare\' => \'LIKE\'
        );
        $searchName[] = array(
            \'search\' => $name,
            \'search_columns\' => array( \'last_name\' ),
            \'compare\' => \'LIKE\'
        );
    }

    if(isset($_GET[\'keywords\']) && !empty($_GET[\'keywords\'])) {
        $keywords = sanitize_text_field( $_GET[\'keywords\'] );
        $searchKeywords = array(
            \'key\' => \'keywords\',
            \'value\' => $keywords,
            \'compare\' => \'LIKE\'
        );
    }

    if(isset($_GET[\'countries\']) && !empty($_GET[\'countries\'])) {
        $country = sanitize_text_field( $_GET[\'countries\'] );
        $searchCountry = array(
            \'key\' => \'country\',
            \'value\' => $country,
            \'compare\' => \'=\'
        );
    }

    if(isset($_GET[\'disciplines\']) && !empty($_GET[\'disciplines\'])) {
        $discipline = sanitize_text_field( $_GET[\'disciplines\'] );
        $searchDiscipline = array(
            \'key\' => \'disciplines\',
            \'value\' => $discipline,
            \'compare\' => \'=\'
        );
    }

    if(isset($_GET[\'roles\']) && !empty($_GET[\'roles\'])) {
        $role = sanitize_text_field($_GET[\'roles\']);
    }

    $args = array(
        \'role\' => $role,
        \'meta_query\' => array(
            \'relation\' => \'AND\',
            array(
                \'relation\' => \'OR\',
                $searchName
            ),
            $searchKeywords,
            $searchCountry,
            $searchDiscipline
        )
    );


    $user_query = new WP_User_Query( $args );

    if ( !empty( $user_query->get_results() ) ) {
        $results = array();
        $count = 0;
        foreach ( $user_query->get_results() as $member ) {
            $member_info = get_userdata( $member->ID );
            $results[] = array(
                \'id\' => $member->ID,
                \'name\' => $member_info->first_name .\' \'.$member_info->last_name,
                \'role\' => $member_info->roles,
                \'keywords\' => $member_info->keywords,
                \'country\' => $member_info->country,
                \'disciplines\' => $member_info->disciplines,
            );

            $count++;
        }

        echo json_encode($results);

    }

    wp_die();
}

我甚至试着在同一个地方创建所有参数的结构，以确保没有额外的“数组”或其他什么，相同的结果。

以下是我在寻找name:

下面是我在寻找role:

我尝试搜索的字段是随插件添加的Paid Memberships Pro 该信息位于\'wp_usermeta\' 桌子以下是其中一个字段“规程”的打印：

$searchName = array(
    \'relation\' => \'OR\',
);

$searchName[] = array(
    \'key\'     => \'first_name\', // meta key
    \'value\'   => $name,        // meta value
    \'compare\' => \'LIKE\'
);

$searchName[] = array(
    \'key\'     => \'last_name\', // meta key
    \'value\'   => $name,       // meta value
    \'compare\' => \'LIKE\'
);

\'meta_query\' => array(
    \'relation\' => \'AND\',
    $searchName,
    $searchKeywords,
    $searchCountry,
    $searchDiscipline
)