in the below query I was getting the booking's event users using a nested query. It does not work and now I need to get the users separately. The EventUsers table has the eventId and the userId foreign keys, I need to get the users and send the response back with each booking event having a list of users
let bookings: Model<BookingAttributes, BookingCreationAttributes>[] =
await dbBooking.findAll({
include: [
{
model: dbUser,
attributes: defaultUsersAttributes,
},
{
model: dbAddress,
attributes: defaultAddressAttributes,
},
{
model: dbEvent,
attributes: defaultEventsAttributes,
// include: [
// {
// model: dbUser,
// through: { attributes: [] },
// attributes: defaultUsersAttributes,
// },
// ],
},
],
order: [[dbEvent, 'startTime', 'DESC']],
offset: offset,
subQuery: false,
limit: 6,
attributes: defaultBookingsAttributes,
});
let eventUsers = await dbUser.findAll({
// where: {
// id:
// }
})