sqlfunction_on_model

Avaliacao::select("
                                          UNIX_TIMESTAMP( CONVERT_TZ( time, '+00:00', @@global.time_zone) ) as time,
                                          idrest,
                                          idcliente,
                                          comentario,
                                          alias,
                                          entrega,
                                          comida,
                                          embalagem,
                                          custobeneficio,
                                          hasreply,
                                          pedido
                                          ")
                                         ->with(['respostas' => function($model){
                                           $model->select("
                                            UNIX_TIMESTAMP( CONVERT_TZ( time, '+00:00', @@global.time_zone) ) as time,
                                            idcomentario,
                                            idrest,
                                            idcliente,
                                            comentario,
                                           ")->get();
                                         }])
                                         ->offset($offset)
                                         ->limit(40)
                                         ->get();