Q:

Select all fields when working with multiple innerjoins

I have a table that looks like this
participant_coach table
id----nutrition_coach----mental_coach----movement_coach
1 ----       2       ----      5     ----      4

coach table
id----name----email----
2 ----NAME---- @@@@ ----

Via an Inner Join I want to get the full data for each coach.
Here's my current query 
SELECT
    c1 AS nutrition_coach,
    c2 AS movement_coach,
    c3 AS mental_coach
FROM participant_coaches AS pc 
INNER JOIN coaches AS c1 ON pc.nutrition_coach = c1.id 
INNER JOIN coaches AS c2 ON pc.movement_coach = c2.id 
INNER JOIN coaches AS c3 ON pc.mental_coach = c3.id 
WHERE participant = + participantId

This doesn't work and it gives an error that it doesn't know the field c1. However when I just want to select 1 property from my c1 table, that does work.
For example, this works
SELECT c1.id AS nutrition_coach, 
       c2.id AS movement_coach, 
       c3.id AS mental_coach

Returns:
mental_coach: 3
movement_coach: 1
nutrition_coach: 2

Is there anyway I can select all the fields from c1instead of only 1? 
Here's what I would like to achieve
Response:
    {
       mental_coach: {
          id: 1
          name: 'MYNAME'
          email '@@@@'
       }
       movement_coach: {
          ...
       }
       nutrition_coach: {
          ...
       }
   }

A:

id name email
Your query is fine, apart from the select.  MySQL doesn't have a notion of "records" that represent the entire row in a table.  You need to list the columns explicitly:
SELECT c1.id AS nutrition_coach_id,
       c1.name AS nutrition_coach_name,
       c1.email AS nutrition_coach_email,       
       c2.id AS movement_coach_id,
       c2.name AS movement_coach_name,
       c2.email AS movement_coach_email,
       c3.id AS mental_coach_id,
       c3.name AS mental_coach_name,
       c3.email AS mental_coach_email

