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, tbtemp1.id

from kakitangan

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

where tbtemp1.id 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":

http://www.yiiframework.com/doc-2.0/yii-db-query.html#join()-detail