video_server/app/Model/PostsModel.php

<?php

namespace App\Model;

class PostsModel extends BaseModel
{
    /**
     * 表名.
     *zcq
     * @var string
     */
    protected $table = 'posts';

    public function user()
    {
        return $this->hasOne(UserModel::class, 'code', 'uid')->select(['code','nick','avatar']);
    }

    // 点赞
    public function likes($uid)
    {
        return $this->hasOne(PostLikesModel::class, 'post_id', 'id')->where(['state' => 1, 'uid' => $uid]);
    }

    // 收藏
    public function favorites($uid)
    {
        return $this->hasOne(PostLikesModel::class, 'post_id', 'id')->where(['state' => 1, 'uid' => $uid]);
    }

    // 评论
    public function comments()
    {
        return $this->hasOne(PostCommentsModel::class, 'post_id', 'id')->where('state', 1);
    }
    
}