How can I insert data using foreach loop in insertByForeach.php?

本文共计128个文字，预计阅读时间需要1分钟。

php插入数据示例：alias('a') - join('__USER__+ac', 'a.openid=ac.openid', 'left') - field('a.*, ac.*, a.id as idd') - order('a.time', 'desc') - select();

遍历列表：foreach($list as $key=> $v) { $cwhere['a.payid']=$list[$key]['id']; $comment=Db::name('l');}

insertByForeach.php

alias('a') ->join('__USER__ ac', 'a.openid = ac.openid', "left") ->field('a.*,ac.*,a.id as idd') ->order('a.time', 'desc') ->select(); foreach($list as $key=>$v){ $cwhere['a.payid'] = $list[$key]['id']; $comment = Db::name('lun')->alias('a')->join('__USER__ ac', 'a.openid = ac.openid', "left")->field('a.*,ac.*')->where($cwhere)->order('time desc')->select(); $list[$key]['comment'] = $comment; }