The following snippet gets all posts from a custom posttype “peoples” where the value of the ACF Field “assigned_team” is equal to the posts name.
$results = get_posts(array(
'numberposts' => -1,
'post_status' => 'any',
'post_type' => 'peoples',
'meta_query' => array(
array(
'key' => 'assigned_team',
'value' => $post->post_name
)
)
));
Is this what you are looking for?