How do I get data using a lookup table in a MYSQL database?

Just store the competence level ID as one field in the personal table and you don't need the lookup table. (Why make things more complex than they need to be?)