Exclude products created by expired members from WooCommerce queries

function pmsc_check_subscription( $user_id ) {
	if (empty($user_id)) return false;
 
	global $wpdb;
 
	$sql = $wpdb->prepare('SELECT user_id, subscription_plan_id, expiration_date, status FROM '.$wpdb->prefix.'pms_member_subscriptions WHERE user_id = %d', $user_id);
	$rows = $wpdb->get_results($sql, ARRAY_A);
	$member_subscriptions = array();
 
	if (!empty($rows)) {
		foreach ($rows as $subscription) {
			if (!empty($subscription['status']) && ($subscription['status'] == 'active' || $subscription['status'] == 'cancel') && time() <= strtotime($subscription['expiration_date'])) {
				$member_subscriptions[] = $subscription['subscription_plan_id'];
			}
		}
	}
 
    if (!empty($member_subscriptions))
		return true;
	else
		return false;
}
 
add_action( 'woocommerce_product_query', 'pmsc_exclude_products_created_by_expired_members' );
function pmsc_exclude_products_created_by_expired_members( $query ) {
	//if you add $query->is_tax() to the if, it will affect only the category pages; else it affects all queries including the shop page
	if( !is_admin() && function_exists('pms_is_post_restricted') && function_exists('pmsc_check_subscription') ) {
		$args = $query->query_vars;
		$args['suppress_filters'] = true;
		$args['posts_per_page'] = get_option( 'posts_per_page' );
 
		$products = wc_get_products($args);
 
		$product_ids = array();
		$restricted_ids = array();
 
		foreach ($products as $product) {
			$author = get_post_field( 'post_author', $product->get_id() );
 
			if ( !pmsc_check_subscription( $author ) )
				$restricted_ids[] = $product->get_id();
		}
 
		$query->set( 'post__not_in', $restricted_ids );
	}
}