https://stiellledm310.blogspot.com/2024/10/how-to-convert-this-query-in-yii.html