Yii：如何从两个不同的cdbcriteria中查找和删除重复的条目

Question

I would like to find the users who liked my products and the users who are following me. However, there might be users that who liked my products and also followed me, which then I will retrieve the same user id for two times. is there anyway to only record the same user id once instead of two times?

Below are the codes that I used to identify the users who liked my products and the users who followed me.

$userid = $productModel->userId;
$followCriteria = new CDbCriteria;
$followCriteria->addCondition("follow_userId = $userid");
$followers = Followers::model()->findAll($followCriteria);
foreach ($followers as $follower) {
$followuserid = $follower->userId;

$productid = $productModel->productId;
$favoriteCriteria = new CDbCriteria;
$favoriteCriteria->addCondition("productId = $productid");
$favoritee = Favorites::model()->findAll($favoriteCriteria);
foreach ($favoritee as $favoriteer) {
$favoriteuserid = $favoriteer->userId;

Answer 1

You can put the ids from first query in an array like this:

...
foreach ($followers as $follower) {
    $idsAlreadyDiscovered[] = $followuserid = $follower->userId;
...

and after you can add a NOT IN condition in second criteria

...
$productid = $productModel->productId;
$favoriteCriteria = new CDbCriteria;
$favoriteCriteria->addCondition("productId = $productid");

// Remove user ids from first query
$favoriteCriteria->addNotInCondition('userId', $idsAlreadyDiscovered);

$favoritee = Favorites::model()->findAll($favoriteCriteria);
foreach ($favoritee as $favoriteer) {
    $favoriteuserid = $favoriteer->userId;
}

[Edit]

Or you can use your $favoriteuserid and $followuserid as arrays and after merge it in a unique.

...
foreach ($followers as $follower) {
    $followuserid[] = $follower->userId;
}
...
foreach ($favoritee as $favoriteer) {
    $favoriteuserid[] = $favoriteer->userId;
}
...
$uniqueIds = array_unique(array_merge($followuserid, $favoriteuserid));