$Data  =  M('a')->where($where)
          ->Field('a.name as aname,b.name as uname,a.*')
          ->join('b on b.jb_id=a.id','LEFT')
          ->order('a.id desc')
          ->select();

  解释:a.* 查询a表所有的字段 
  .name as aname 转换a表中的name重复字段为aname

posted on 2018-07-11 16:52  Cc_Pz  阅读(179)  评论(0)    收藏  举报