Yii2如何将mysql查询转换为yii \ db \ query

I am using mysql query as

SELECT tpa_name
FROM `patient_detail` p, daily_ward_entry d
WHERE d.general_regn_no = p.general_regn_no
AND d.id =3

I am getting the result as 1 and Null when d.id =1

But in controller public function actionCharges($id)

$query = (new \yii\db\Query())
    ->select('tpa_name')
    ->from('patient_detail') 
    ->innerJoin('daily_ward_entry', 
   'daily_ward_entry.general_regn_no =    patient_detail.general_regn_no');

   $command = $query->createCommand();
   $rows = $command->queryAll();
    var_dump($rows);exit;

when I am viewing the page using daily-ward-entry/charges&id=3 I am getting the dump values as Null in all cases. I am scratching my head what I am doing wrong here?