//重建索引
$query->select(['A.prod_id', 'A.name', 'B.train_departure', 'B.train_departure_id'])
->joinWith('main')->joinWith('offer')->joinWith('train')
->groupBy("A.prod_id, B.train_departure_id")
->orderBy('prod_line_main.code, prod_com.prod_id desc')->indexBy(function ($row) {
return $row['prod_id']. $row['train_departure_id'];
})->asArray();
當前模型為A, A與B是一對多的關系
若不加indexBy $row['train_departure_id']則groupBy只會返回A的總條數(shù)
indexBy('day')返回以day為索引的數(shù)組
->select('day, price')
->limit(2)
->indexBy('day')->orderBy('day asc')//價格排序升序
->asArray()
->all();
