Yii2.0
关联表
/**
* 关联用户表
*/
public function getUserprofile()
{
return $this->hasMany(Userprofile::className(), [‘user_id’ => ‘user_id’]);
}
$query= ReleaseComment::find()
->joinwith('userprofile')
->where(" `update` > :time", [':time'=>$time])
->andWhere(['like', "text", $name])
->orderBy(['update'=>SORT_DESC]);