我用的是codeigniter，
我有一个表，我将数据插入数据库，数据插入两次取决于一年六个月。
所以我的表数据是

------------------------------------------------
id |m_id  | primary | secondary  | Duration
------------------------------------------------
1  |  1   | 100     | 80         | 12m
------------------------------------------------
2  |  1   | 50      | 40         | 6m
------------------------------------------------
3  |  2   | 300     | 150        | 12m
------------------------------------------------
4  |  2   | 150     | 70         | 6m
------------------------------------------------
5  |  3   | 500     | 300         | 12m
------------------------------------------------
6  |  3   | 300      | 200         | 6m

现在我必须从数据库中获取数据，我希望我的输出像这样

--------------------------------------------
id  |m_id | primary        | secondary    
    |     | 12m |6m        |12m   |6m        
--------------------------------------------
1   |1    |100  |50        | 80  |40  
--------------------------------------------
2   |2    |300  |150       | 150  |70 
--------------------------------------------
3   |3    |500  |300       | 300  |200

所以我试图在视图页上显示数组，所以 print_r($row) 我得到的结果是

stdClass Object ( [id] => 1 [m_id] => 1 [primary] => 100 [secondary] =>80 [Duration] => 12m ) 
stdClass Object ( [id] => 2 [m_id] => 1 [primary] => 50  [secondary] => 40 [Duration] => 6m) 
stdClass Object ( [id] => 3 [m_id] => 2 [primary] => 300 [secondary] => 150 [Duration] => 12m)
stdClass Object ( [id] => 4 [m_id] => 2 [primary] => 150 [secondary] => 70 [Duration] => 6m)
stdClass Object ( [id] => 5 [m_id] => 3 [primary] => 500 [secondary] => 300 [Duration] => 12m)
stdClass Object ( [id] => 6 [m_id] => 3 [primary] => 300 [secondary] => 200 [Duration] => 6m  )

但是在列表中，我得到了输出。我没有加金额，因为我拿错了金额。这不是例外的输出。我的模型查询中有一些问题。

--------------------------------------------
id  |m_id | primary        | secondary    
    |     |12m  |6m        |12m   |6m 
--------------------------------------------
 1  |1    |     |          |      | 
 2  |1    |     |          |      | 
 3  |2    |     |          |      | 
 4  |2    |     |          |      |
 5  |3    |     |          |      | 
 6  |3    |     |          |      |

我的视图代码是

<table id="list" border="1">
        <thead>
  <tr>
    <th rowspan="2">id</th>
    <th rowspan="2">m_id</th>
    <th colspan="2">Primary</th>
    <th colspan="2">Secondary</th>
  </tr>

  <tr>
    <th>12m</th>
    <th>6m</th>
    <th>12m</th>
    <th>6m</th>
  </tr>
</thead>
        <tbody> 

        <?php 

        if($activityfeeslist)
        {
            $n = 1;
            foreach ($activityfeeslist as $rows)
            //print_r($rows);
            if($rows->Duration=='12m'){
                $primary12=$rows->primary;
                $secDep12=$rows->secondary;

            }else{
                $primary6=$rows->primary;
                $secDep6=$rows->secondary;
            }
            {?>
              <tr>
                <td><?php echo $n++;?></td>
                <td><?php echo $rows->m_id;?></td>

                <td><?php echo $primary12;?></td>
                <td><?php echo $primary6;?></td>

                <td><?php echo $secDep12;?></td>
                <td><?php echo $secDep6;?></td>

        <?php 
        }}?>
        </tbody>
      </table>

控制器

public function activityFees()
  {
        $data['activityfeeslist'] = $this->Fees_model->activityFessList();
        $this->load->view('fees/activityFees',$data);
  }

模型

public function activityFessList(){
        $getDetails = array('tbl_activityFees2.is_feesActive'=>1);
        $result = $this->db->where($getDetails)
                           ->select("*")
                           ->from('tbl_activityFees2') 
        ->join('activity_name','activity_name.m_id=tbl_activityFees2.m_id')
                              ->get()
                              ->result();
    if($result)
        {
           return $result;  
        }
        else 
        {
           return 0;    
        }
        }

你能帮我解决这个问题吗？