Supabase auth auth.uid() doesn't work but user_id does?

Yes, I just answered it in an another topic, with the current Supabase Plugin for WeWeb version, you need to have the same SELECT RLS as well.

Check this out