LEFT JOIN with db_select()
Use the below code for fetching values. It will give you field_naam_value field data.

$naam = db_select('profile', 'pf');
$naam-&gt;join('field_data_field_naam', 'fd', 'pf.pid = fd.entity_id');
$all_names = $naam-&gt;fields('fd', ['field_naam_value'])
  -&gt;condition('pf.uid', 4, '=')
  -&gt;execute()
  -&gt;fetchAll();
foreach ($all_names as $record) {
  die;
}