Welcome to the Auth0 Community!
Thank you for posting your question. Based on your description, you are definitely on the correct path. With many to one relations between these tables storing auth0_id as a foreign key, it is a perfectly valid way to have this relationship between tables. I would recommend going with that pattern.
Thanks
Dawid