Use inner join or left join update data by query of yii2

yii version:

I want to exce SQL :
update ce a INNER JOIN bi b on a.project_id=b.project_id and b.deleted=0 set a.ce =b.ce ,a.noi=b.noi
but , i don`t find a way to user query of yii (left join or inner join) .
can you help me .

thanks .