How to make a nested query on a list id?

Question

PHP

There is a table words with fields: id , word

id	word
111	word 1
222	word 2
333	word 3
444	word 4
555	word 5
666	word 6

There is a test table with fields: id , word_id_1 , word_id_2 (word_id_* = id from the first table)

id	word_id_1	word_id_2
one	111	222
2	111	333
3	111	444
4	111	666

Whether it is possible to make for one request the following:
1. We select from the test table of record where word_id_1 = id; (goal is to get word_id_2 );
If one record were returned here, everything would be simple, from 1 to ~100 records will be returned here.
2. Get records from the words table , where id = word_id_2 (get information on each id from the previous step);

public function getDetailPage($id) {
    $params = [
      'id' => $id, // id из таблицы words
    ];
    return $this->db->row('SELECT * FROM words WHERE id = :id', $params);
  }
  public function row($sql, $params = []) {
    $result = $this->query($sql, $params);
    return $result->fetchAll(PDO::FETCH_ASSOC);
  }

Known: id from the words table (in the example it is equal to 111)
Ultimate goal: to get data on the initially known id from the words table , and also get information on the elements bound to it in the test table.
All data is stored in the first table, in the second - only relationships.
Based on the example, data should come from the words table for all elements except id = 555 .

Answer 1

JOIN to help you