sql转tp5.0语句

Question

SELECT LAST_INSERT_ID()

titles,
dizhi,
laiyuan,
xingxiang,
sum(jine) AS zonghe,
real_name,
dianhua,
a.id

FROM

`think_hetong` `a`

INNER JOIN think_zhanghao w ON w.zyzh = a.laiyuan
GROUP BY

`titles`

HAVING

zonghe > 1000

AND zonghe < 20000
ORDER BY

`zonghe` DESC,
`dizhi`

LIMIT 0,

有没有大佬会的，在线急

Answer 1

https://www.kancloud.cn/manua...

Answer 2

LAST_INSERT_ID()主要是这个的不知道怎么用

Answer 3

你是不是要获取上一个添加的ID

Answer 4

self::name("think_hetong")

         ->alias("a")
         ->field("titles,dizhi,laiyuan,xingxiang,sum(jine) AS zonghe,real_name,dianhua,a.id")
         ->join("think_zhanghao w",'w.zyzh = a.laiyuan','insert')
         ->group("a.titles")
         ->having("zonghe > 1000 AND zonghe < 20000")
         ->order("zonghe",'desc')->limit(0,10);
         
         你这上面的字段有些没写明白 是哪张表的啊  是a的 还是 w的?