convert this sql statement to yii2 active record query

This is a sql statement i use to get data i desire

select kakitangan.nama, kakitangan.nokp,

from kakitangan

left join (select id,tarikh, kakitangan from harikerja where tarikh = '2016-05-15') as tbtemp1 on = tbtemp1.kakitangan

where is null

I alredy has a working Kakitangan and Harikerja model generated using Gii.

I understand the basic to use active record for select, where, andWhere, but not to create subquery and use it in a join.

So how to convert the sql statement above to yii2 active record query?

You can provide a sub-query through "join":