public function actionTestJoin()
{
//Yii::$app->message->display('I am Yii2.0 Programmer');
echo Yii::$app->params['hostID'];
$items = User::find()->joinWith(['pi' => function ($q) {
$q->from(PersonalInformation::tableName() . ' p');
}])->with(['userEducations' => function ($q) {
$q->select(['id', 'ue_id', 'ei_id']);
}])->select(['{{user}}.pi_id', 'id', 'username', 'password_hash', 'p.pi_name'])->where(['IN', 'pi_ic_or_passport', ['880214565399', '870507015025', '880906355448', '880722435283', 'B153796']])->asArray()->all();
//print_r($items);
}
