Query with db_select() to select node by id and join field and terms
I hope this works for you:

 $query = db_select('node','n');
 $query-&gt;join('field_data_field_projectresources','p','p.entity_id = n.nid');
 $query-&gt;fields('n',array('yourfieldnames'))
       -&gt;fields('p',array('yourfieldnames'))
       -&gt;condition('n.nid','5');
 $result = $query-&gt;execute();


Here is another answer that will help you very much.

Check out documentation for 'join' on drupal.org.