Find value in array and return with new from different array

var mainsByKid = {}; // if the keys are integers (and not sparse), use an array
for (var i=0; i<mains.length; i++) {
     var main = mains[i],
         key = main.properties.kid; // must be unique
     mainsByKid[key] = main;
}

mainsByKid[1];

newArray[indexNum++] = i;

            select distinct room_category
              from room_category

select a.room_category, 
       group_concat(b.room_name ORDER BY b.room_name) vacancies
  from (select distinct id, room_category from room_category) a
  left join 
       (select rct.room_category AS room_category,
               rn.room_name 
          from room_category rct  
          left join room_name rn on rn.room_category = rct.id
          left join patient_detail pd on rn.id = pd.bed_type
                 and (isnull(pd.discharge_date) or now() 
                      between pd.admission_date and pd.discharge_date)
         where isnull(pd.id) 
         order by rct.room_category, rn.room_name
    ) b on a.room_category=b.room_category
group by a.room_category
order by a.room_category

const keys = ["Name","Type"]
var counterObj = {}
let keyForCounterObj
arrayOfObjects.forEach((obj)=>{
    keyForCounterObj = ''
    keys.forEach((key)=>{
        keyForCounterObj += String(obj[key])
}
if(counterObj[keyForCounterObj]){
    counterObj[keyForCounterObj].times ++
}else{
    counterObj[keyForCounterObj] = {
        ...obj,
        times:1
}}}

counterObj = {
    AppleFruit: {
        Name:"Apple",
        Type:"Fruit",
        times:3,
    },
    CarrotVegetable:{
        Name:"Carrot",
        Type:"Vegetable",
        times:4,
    }
}

let newArrayOfObjects = []
const counterObjKeys = Object.keys(counterObj)
counterObjKeys.forEach((key)=>{
    newArrayOfObjects.push(counterObj[key])
}