Sequelize with MYSQL: Raw query returns a "duplicate" result

Question

I have this method that performs a raw query:

 Friendship.getFriends= async (userId)=>{

      const result = await sequelize.query(`select id,email from users where 
      users.id in(SELECT friendId FROM friendships where friendships.userId = 
     ${userId})`);

      return result;
   };

The result seems to contain the same exact data, but twice:

[ [ TextRow { id: 6, email: '[email protected]' },
TextRow { id: 1, email: '[email protected]' } ],
[ TextRow { id: 6, email: '[email protected]' },
TextRow { id: 1, email: '[email protected]' } ] ]

Only two records should actually be found by this query(id's 1 and 6), yet it returns an array with the same records twice.

Can somebody explain me what's going on here?

Edit: the models:

module.exports = (sequelize, DataTypes) => {
   const User = sequelize.define('User', {
     email: { type: DataTypes.STRING, unique: true },    
     password: DataTypes.STRING,
     isActive:{type:DataTypes.BOOLEAN,defaultValue:true}
  });

module.exports = (sequelize, DataTypes) => {
   const Friendship = sequelize.define('Friendship', {
     userId: DataTypes.INTEGER,    
     friendId: DataTypes.INTEGER,      
  });

Answer 1

Try to set query type to SELECT in the second argument.

sequelize.query(queryString, {type: sequelize.QueryTypes.SELECT})

Answer 2

I am not sure but try below code.

const result = await sequelize.query("select id,email from users where 
      users.id in(SELECT friendId FROM friendships where friendships.userId = 
     ${userId})", {type: sequelize.QueryTypes.SELECT});

One more thing : Use join instead of in