Remain the sort of constraint when get list

I have 3 table data, video - user - score, all link within user_id
Now i want to get video based on user_id thats sorted by score.
But the video return didnt follow the sort user_id get from score
Here is the example

  1. Get video by searching video table where user_id is in a List of user_id
  2. List of user_id is get from Score table, which is sorted by Score_total
  3. Result: REsult List of user_id return from step 2 is OK: user_id 43013100 is no1 …
  4. Result: Result video from step 1 is WRONG: user_id 947520 is no 1

So how to let Bubble remain the sorting, or is it need a plugin to do that ?