How to get LastInsertID() from a specific user?

Question

Yii

Good afternoon. The table has an auto-increment field that is unique for each user - this is the contract number, which for each new contract must be incremented by 1, regardless of the contract numbers of other users. Tell me, is there any tool in yii2 that allows you to pull LastInsertID () from a specific user? If on fingers, then something like LastInsertID()->where('user-id' => $id); Or is there a better way to implement this functionality?

Answer 1

$lastUserId = Model::find()->orderBy(['id' => SORT_DESC])->where(['user-id' => $id])->one()->id;