php - returning all records with the same ID but different values

I've been trying this query

Model::find()
 ->innerJoin('TranslationTable', 'TranslationTable.model_id = Model.id')
 ->where(['IN', 'translation_code', $arrayOfTranslationCodes])
 ->asArray()
 ->all();

The translation table contains multiple rows with the same ID but with different translation codes.

This query only returns the first matching locale for a given ID. How would I retrieve the other translation codes for a given ID?

Answer

Solution:

This is the solution that I came to:

$query = Model::find()
 ->innerJoin('TranslationTable', 'TranslationTable.model_id = Model.id');

foreach ($arrayOfTranslationCodes as $translation)
 {
   $query->andWhere(['OR', 'translation_code', $translation])
 }

 $queryResponse = $query->asArray()->all();

This allowed me to find rows with the same id, but have different translations. You need to store the $query->asArray()->all(); as $query itself just returns the active query.

Source