Use Below Code for fetching values.it will give you 'field_naam_value' field data.             

 

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