Phalcon - How do i do a SELECT IN Subquery with Phalcon models ?

I need to know how to do i do a subquery type selection with phalcon models?

for example i want to select all the users who viewed me, they are stored in the UserView table with columns 'id','userfrom','userto' (mapped by User table userid to either userfrom or user_to)

so i want to select all the users who has a userto as with the current user, and group by userto make sure i only get one recorded, I wrote below function to do this but there is fundamental two problems

  1. Is how to do sub-query using phalcon models

  2. Is my logic correctly applied on the back-end of the DB (as i cant see real executed query)

public function getUserWithViewedMe($limit=1000000){

return User::query()


->andWhere(" XYZ\Models\UsersView.userfrom IN :userid: ",array('userid' => $this->user->userid) )


->order("XYZ\Models\ DESC ")




This returns empty set...



You can take look at to see how to use subqueries