How to get values ​​that are in another table?

Question

Laravel

I have 2 tables:

1. systems -> id, name
2. keys -> id, system_id

And such a question, how to get records from the table: systems, if id is in the table: keys -> system_id, and also: name in the systems table is not equal to: test1 and test2.