select * from web_users
left join web_access on web_users.web_roles_id = web_access.web_roles_id
left join web_route on web_access.web_route_id = web_route.id
where web_users.id = 1 and web_access.isAccess = 1

@Table({ timestamps: false, tableName: "web_users" })
export default class User extends Model {
  @AutoIncrement
  @Column({ primaryKey: true })
  public id: number

  @Column({ field: "login" })
  public login: string

  @Unique
  @Column
  public email: string

  @Column
  public password: string

  @Column({ field: "FirstName" })
  public firstName: string

  @Column({ field: "LastName" })
  public lastName: string

  @Column({ field: "web_roles_id" })
  public roleId: number

  @HasMany(() => Access)
  accesses: Access[]

  public validatePassword(password: string) {
    return this.password === password.trim()
  }

  public toPlainObject() {
    return {
      id: this.id,
      login: this.login,
      email: this.email,
      firstName: this.firstName,
      lastName: this.lastName,
      roleId: this.roleId
    }
  }
}

@Table({ timestamps: false, tableName: "web_access" })
export default class Access extends Model {
  @AutoIncrement
  @Column({ primaryKey: true })
  public id: number

  @Column({ field: "web_route_id" })
  public routeId: number

  @Column({ field: "isAccess" })
  public isAccess: boolean

  @ForeignKey(() => User)
  @Column({ field: "web_roles_id" })
  public roleId: number

  @BelongsTo(() => User)
  user: User

  public toPlainObject() {
    return {
      id: this.id,
      roleId: this.roleId,
      routeId: this.routeId,
      isAccess: this.isAccess
    }
  }
}

const user = await User.findOne({ where: { email: payload.email.trim() }, include: [Access] })

Executing (default): SELECT [User].[id], [User].[login], [User].[email], [User].[password], [User].[FirstName] AS [firstName], [User].[LastName] AS [lastName], [User].[web_roles_id] AS [roleId], [accesses].[id] AS [accesses.id], [accesses].[web_route_id] AS [accesses.routeId], [accesses].[isAccess] AS [accesses.isAccess], [accesses].[web_roles_id] AS [accesses.roleId] FROM [web_users] AS [User] LEFT OUTER JOIN [web_access] AS [accesses] ON [User].[id] = [accesses].[web_roles_id] WHERE [User].[email] = N'doc@doc.ua';

Executing (default): SELECT [id], [login], [email], [password], [FirstName] AS [firstName], [LastName] AS [lastName], [web_roles_id] AS [roleId] FROM [web_users] AS [User] WHERE [User].[id] = 2;

LEFT OUTER JOIN [web_access] AS [accesses] ON [User].[id] = [accesses].[web_roles_id]