具体如下：

使用视图模型查询的时候 结果是这样的

array(6) {
 [0] => array(5) {
  ["picTitle"] => string(7) "标题2"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-26 11:59:50"
  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550278b7db.jpg"
 }
 [1] => array(5) {
  ["picTitle"] => string(7) "标题2"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-26 11:59:50"
  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/54755027ab89b.jpg"
 }
 [2] => array(5) {
  ["picTitle"] => string(7) "标题2"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-26 11:59:50"
  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550273b753.jpg"
 }
 [3] => array(5) {
  ["picTitle"] => string(7) "标题2"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-26 11:59:50"
  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/54755027d8488.jpg"
 }
 [4] => array(5) {
  ["picTitle"] => string(33) "同步写入信息和附件表里"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-20 16:05:16"
  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141120/546da0746edb8.png"
 }
 [5] => array(5) {
  ["picTitle"] => string(33) "同步写入信息和附件表里"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-20 16:05:16"
  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141120/546da0784831c.png"
 }
}

想要的结果是这样

array(2) {
 ["0"] => array(5) {
  ["picTitle"] => string(7) "标题2"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-26 11:59:50"
  ["pictureurl"] => string(223) "attachment/picture/uploadify/20141126/547550278b7db.jpg,attachment/picture/uploadify/20141126/54755027ab89b.jpg,attachment/picture/uploadify/20141126/547550273b753.jpg,attachment/picture/uploadify/20141126/54755027d8488.jpg"
 }
 ["1"] => array(5) {
  ["picTitle"] => string(33) "同步写入信息和附件表里"
  ["picCategroy"] => string(6) "海报"
  ["picAuthor"] => string(12) "星耀学园"
  ["picPostTime"] => string(19) "2014-11-20 16:05:16"
  ["pictureurl"] => string(111) "attachment/picture/uploadify/20141120/546da0746edb8.png,attachment/picture/uploadify/20141120/546da0784831c.png"
 }
}

完整实例开始

控制器 里 根据生成的SQL 语句在phpmyadmin里运行 出现排序规则不一致的情况 两个表的字段 排序规则不一致 整表排序规则一样的情况下

PictureController.class.php

  public function Pic(){
     $PicModel =D('PicView');

    /* dump($PicModel);*/

    $s1= $PicModel->field('picTitle,picCategroy,picAuthor,picPostTime,pictureurl')->order('picPostTime desc')->select();
   /* dump($PicModel->getLastSql()); 查询最后的sql 语句*/
   /* dump($s1);*/
    $zhengli = $this->mergePictureURL($s1);
   /* dump( $zhengli );*/

    $this->assign("content",$zhengli);

    $this->display();

  }

视图模型里

PicViewModel.class.php

 array('picTitle','picToken','picCategroy','picAuthor','picPostTime','_as'=>'Picture'),
    'PictureAttachment' =>array('pictureid','pictureurl','creattime','_on'=>'Picture.picToken = PictureAttachment.pictureid','_as'=>'PictureAttachment'),

  );
}

视图里

  
  



 
  {$data.picTitle}