Hello @mmmzzss and welcome to the Quicksight community!
In this example, is the user_id and the assets always going to be the same? For example, will the user_id 10000 always have 10,000 in the assets column?
If so, you could try the solution from this post:
Let me know if this helps!