构造具有一对多关系的Eloquent ORM输出

Question

I'm not sure if I've got the right wording in the title, but this is what I'm after:

I've got a 'designs' table and a 'variables' table. It is a one-to-many relationship such that a design has many variables.

How can I get the data as a single json object?

Answer 1

I believe your problem is with the way you are using your relationships. You are only either getting the Design model or a collection of Variables, when you need to get both.

This will eager load the variables with the design and return them as json.

$data = Design::where('id', $id)->with('variables')->get();
return Response::json($data, 200);