Laravel 5.8显示另一个表的数据，如join

Question

我需要如何在另一个表中显示数据，如MySQL join或类似的东西

MySQL示例

​

​

我的代码

模型用法

class Usuario extends Model {
    protected $table = 'usuarios';
    protected $primaryKey = 'idusuarios';
    protected $filliable = [
        'cedula', 'nombre', 'tele1', 'tele2', 'correo', 'direccion',
        'user_name', 'user_pass', 'fecha_ingreso', 'usu_idrol'
    ];

    public function Usuario() {
        return $this->hasOne('app\Roles','idrole','usu_idrol','desc_rol');
    }

    const CREATED_AT = NULL;
    const UPDATED_AT = NULL;
}

模型角色

class Roles extends Model {
    protected $table ='roles';
    protected $primarykey  = 'idrole';
    protected $filliable = ['desc_rol'];

    public function Roles() {
        return $this->belongsTo('app\Usuario', 'usu_idrol', 'idrole');
    }
}

控制器用法

public function index(Request $request) {
    if (!$request->ajax()) return redirect('/');
    $usuarios = Usuario::all();
    return $usuarios;
}

查看用法

​

​

这就是我需要的

​

​

Answer 1

在将数据返回到vue实例的控制器中尝试此操作

//get all the users from the database (in your controller)
//you need to create a new array so as to easily map the role in the returned results
return Usuario::with('Usuario')->get()->map(function($role) {
            return [
                'field1' => $role->field1,
                'field2' => $role->field2,
                'field3' => $role->field3,
                'field4' => $role->field4,
                'field5' => $role->field5,
                'rol' => $role->Usuario->desc_role
            ];
        });