mypmpro-filter-member-directory-search-into-map-search.php

<?php //do not copy

/**
 * This recipe filters the search request from the member directory into the membership map
 *
 * You can add this recipe to your site by creating a custom plugin
 * or using the Code Snippets plugin available for free in the WordPress repository.
 * Read this companion article for step-by-step directions on either method.
 * https://www.paidmembershipspro.com/create-a-plugin-for-pmpro-customizations/
 */

function mypmpromm_filter_searches( $sql_parts, $levels, $s, $pn, $limit, $start, $end ) {
    
    if( ! empty( $_REQUEST['ps'] ) ) {
        $s = sanitize_text_field( $_REQUEST['ps'] );
		$sql_parts['WHERE'] .= "AND (u.user_login LIKE '%" . esc_sql($s) . "%' OR u.user_email LIKE '%" . esc_sql($s) . "%' OR u.display_name LIKE '%" . esc_sql($s) . "%' OR um.meta_value LIKE '%" . esc_sql($s) . "%') ";
	}

    return $sql_parts;
}
add_filter( 'pmpro_membership_maps_sql_parts', 'mypmpromm_filter_searches', 10, 7 );