Hello how can i create and Select and Insert into with query builder.
I have a query builder with an searchCriteria which works. In this query a user can filter other users by country and region -> so get user with ID 100, 200, 300 for example.
users = $this->modelsManager->createBuilder() ->from(['u' => 'Vokuro\Models\Users']) ->join('Vokuro\Models\SearchCriteria' , "s.country = u.country AND u.region LIKE CONCAT(SUBSTRING(s.zipcode, 1, 1),'%')",'s') ->where('s.usersId = :id: AND u.id != :id:',array('id' => $id)) ->orderBy('u.id') ->getQuery() ->execute();
Now i want to extract the users Id's from this object and insert the ids into another table for example INFO. Is it possible to extend this query? And how?