Generate a custom member list query by filtering the original SQL Query and modifying as needed

custom_filtered_pmpro_members_list_sql.php

<?php
/**
 * Generate a custom member list query by filtering the original SQL Query and modifying as needed 
 *
 * Add this code to your site by following this guide - https://www.paidmembershipspro.com/create-a-plugin-for-pmpro-customizations/
 */

 function custom_filtered_pmpro_members_list_sql( $sqlQuery ) {

  //Here modify the SQL Query to avoid email dups
  
  return $sqlQuery 

}
add_filter( 'pmpro_members_list_sql', 'custom_filtered_pmpro_members_list_sql' );