可以在主循环内调用另一个循环并执行另一个查询

$data=$this->db->get($firstquery) // first query record in array
$second=$this->db->get($second_query);  // second query record in array
foreach($records as $rec)
{   
         foreach($second as $sec)   //second query loop
         {
          //enter code here
         }
   $data22 = array
        (
                'file_id'=>$rec['id'],  // here is first query result
                'text'=>    // How to pass second query result here 
        );
}