duanju_manage/modules/Channel/Http/Controllers/UserMiniprogramController.php

<?php

namespace Modules\Channel\Http\Controllers;

use Catch\Base\CatchController;
use Illuminate\Http\Request;
use Modules\User\Models\User;
use Modules\Channel\Models\UserHasMiniprograms;

class UserMiniprogramController extends CatchController
{
    public function __construct(
        protected readonly User $user,
        protected readonly UserHasMiniprograms $userHasMiniprograms
    ) {
    }

    public function index(Request $request)
    {
          return $this->userHasMiniprograms->join('miniprogram','miniprogram.id','=','user_has_miniprograms.miniprogram_id')
          ->where('user_has_miniprograms.is_enabled',1)
          ->where('uid',$this->user->id)
          ->select('user_has_miniprograms.miniprogram_id','miniprogram.name','miniprogram.play_name')
          ->get();
    }
}