as you say, its MySQL

foreign key constraints don’t come into consideration for read queries - so should be fine