How to get json from two tables in database?

Question

PHP

Let's say there is a database that has two tables 'author' and 'books'.
the 'books' table has the fields 'title' and 'author_id'.
You need to get json like:

{"title": "Book title", "name": "Author's name"}

Please tell me how to do it right.

Answer 1

Select * from avtor a, book b where b.autor_id=a.id
Neither and then collect the array and do json_encode