How to convert sql query to yii2 (ActiveRecord)?

Question

Yii

There is a request

SELECT `tblRegistrars`.`iIndex` as `iRegistrarID`, 
                            `tblDomains`.`iIndex` as `iIndex`, 
                            `tblDomains`.`sName` as `sName`,
                            `tblRegistrars`.`sOrgR` as `sRegistrar`, 
                            `tblCustomers`.`sOrgRU` as `sOrg`, 
                            `tblCustomers`.`sNameRU` as `sNameRU`, 
                            `tblCustomers`.`eType` as `eType`, 
                            `tblDomains`.`dtRegistered` as `sRegistered`, 
                            `tblDomains`.`dtPassed` as `sPassed`, 
                            `tblRegistrars`.`rDeposit` as `rDeposit`, 
                            `tblRegistrars`.`rPrice` as `rPrice`, 
                            `tblRegistrars`.`eDepositCurrency`, 
                            `tblDomains`.`dtExpired` as `sExpired` 
                       FROM `tblDomains`, `tblCustomers`, `tblRegistrars` 
                      WHERE `tblDomains`.`iRegistrarID` = `tblRegistrars`.`iIndex` 
                        AND `tblDomains`.`iCustomerID` = `tblCustomers`.`iIndex` 
                        AND `tblDomains`.`dStatus` IN ("A_REG", "P_REG")
                   ORDER BY `tblRegistrars`.`iIndex`

How to convert it to yii2, activerecord?

Answer 1

You need to read the documentation and redo it.
The word remake implies that you will have to do something!)
Otherwise, you can turn to a freelance site.