I have tried this query in phpmyAdmin

SELECT COUNT(*) 
FROM meal_participants_user 
INNER JOIN user ON meal_participants_user.userId = user.id 
ORDER BY meal_participants_user.mealId ASC;

And got in phpMyAdmin the answer 6,

But when I ran this in a nodeJs app,

I got this answer

|count(*)|
| 8      |

What causes this problem and how can I fix it?

note: all data are not real Tables

User:

meal_participants_user