MySQL—嵌套外键(包含多个表)

I have table bus and routes, and table fare_t has bus and routes' primary key as foreign key. And another table time_t has fare_t's primary key as foreign key. Now I want to make a query and join them together in such a way that the query returns data from table time_t containing data from table fare_t along with the data from table bus and routes of which's primary key is added as foreign key in table fare_t. I have table bus and routes, and table fare_t h