How to get static data of a function when selecting a model in Yii2?

Question

Yii

get company models via $data = Company::find()->all();
the sum of active projects at the moment is also considered in the model
after sending via Json::decode();
How can I get the sum of active projects of the company in Json format?

Answer 1

1. why not right away? asArray()->all()?
2. run the resulting array through a loop, something else and calculate the required amount already there and add a field ..
echo Json::encode(['data'=>$data, 'sum'=>$YouSumm]);