SELECT *, ( SELECT name FROM category JOIN film_category USING(category_id) WHERE film_id = film.film_id ) FROM film
You should use the app on a larger display:
MySQL EXPLAINs include a lot of data that can not be simplified enough for a great experience on small mobile screens.