anwppro query

<?php

$players = get_posts( [
    'post_type'   => 'anwp_player',
    'numberposts' => - 1,
] );

$players = array_filter( $players, function ( WP_Post $player ) {
    $club_id = $player->_anwpfl_current_club;

    return ! ( $club_id && get_post_status( $club_id ) === 'publish' );
} );