Get all user profiles from list of users
Your first problem is that you send uids instead of pids. First argument of profile2_load_multiple is $pids which are profile2 ids.

Try this code:

$users = entity_load('user');
$arrayuids = array_keys($users);

$query = new EntityFieldQuery();    
$query-&gt;entityCondition('entity_type', 'profile2')
    -&gt;propertyCondition('uid', $arrayuids, 'IN');

$profile = $query-&gt;execute();

dsm($arrayuids);
dsm($profile);


I haven't tested it but it should work.