How to load all field values from multiple entities?

Question

I have an EFQ that finds the users whose field values match a given array of values:

  $users_query = new EntityFieldQuery();

  $users_query->entityCondition('entity_type', 'user')
    ->fieldCondition('field_my_field', 'value', $array_of_values);

  $users_query_result = $users_query->execute();

This will create a list of uid's but I need to know which uid goes with which value in the array.

Answer 1

EFQ will return an entity stub, if you want the fully loaded entities, you can try something like:

// Build query
$query = new EntityFieldQuery();
$query->entityCondition('entity_type', 'user');
$query->fieldCondition('field_my_field', 'value', $values);
// Execute for result
$result = $query->execute();
// If has data
if (!empty($result['user'])) {
  // Load users
  $accounts = entity_load('user', array_keys($result['user']));
  // If using devel
  // dpm($accounts);
}else{
  // No results
}

Answer 2

The only way I suggest is loading the user objects with entity_load(), or user_load_multiple() using the array returned from $users_query->execute(). That is the only method that always work.
On Drupal, entity fields can be stored on a different database engine, or on a Mongodb database; directly querying the database could not work, similarly to directly querying the database instead of using cache_get(), or cache_set().