adonis lucid join

JavaScript
await Database
  .table('users')
  .innerJoin('accounts', 'user.id', 'accounts.user_id')
Source

Also in JavaScript: