with relation

2 files changed, 10 insertions, 0 deletions

diff --git a/db/index.js b/db/index.js
index 8c94a4d3..81c0fe46 100644
--- a/db/index.js
+++ b/db/index.js
@@ -124,6 +124,11 @@ Payment.belongsTo(Payment, {
   foreignKey: "fee_payment_id"
 });
 
+Payment.belongsTo(User, {
+  as: "with",
+  foreignKey: "with_id"
+});
+
 db.Order = Order;
 
 export default db;
diff --git a/routes/payments.js b/routes/payments.js
index 678b646c..999cba36 100644
--- a/routes/payments.js
+++ b/routes/payments.js
@@ -125,6 +125,11 @@ app.get("/payments", auth, async (req, res) => {
       model: db.Account,
       as: "account"
     },
+    include: {
+      attrs: ["username", "profile"],
+      model: db.User,
+      as: "with"
+    },
     limit,
     offset
   });