tp 合并某个字段显示concat

Db::table('think_user')->field(['id','concat(name,"-",id)'=>'truename','LEFT(title,7)'=>'sub_title'])->select();

$this->view->assign('warehousedata', db('warehouse')->where('status',1)->where('supplier',0)->column('id,concat(name,"-",number) as name') );