如何获取yii2中第一行表的条件？

Question

I need to get the first row of table with where condition.

(new Query())
        ->select('*')
        ->from('stock_in')
        ->where("user_id = '$request_user_id'")
        ->andWhere("product_id = '$product_id'")
        ->andWhere("remaining_quantity > '0'")
        ->one();

Answer 1

Yes i got my answer.Use Limit there

(new Query())
        ->select('*')
        ->from('stock_in')
        ->where("user_id = '$request_user_id'")
        ->andWhere("product_id = '$product_id'")
        ->andWhere("remaining_quantity > '0'")
        ->limit('1')
        ->one();