<?php
//gid 希望从小程序返回
$return = [];
$user_gourp_id=\Phpcmf\Service::M()->table('member_group_index')->where('gid', 1)->select(['uid'])->get();
$data = \Phpcmf\Service::M()->where('id',$user_gourp_id['uid'])->table('member')->getAll();
if ($user_gourp_id) {
    foreach ($user_gourp_id as $r) {
        $return[] = [
            'id' => $r['id'],
        ];
    }
}

$return = [];
$data = \Phpcmf\Service::M()->table('member')->where('id in (select uid from dr_member_group_index where gid=1)')->getAll(); // dr_改成自己的表前缀
if ($user_gourp_id) {
    foreach ($user_gourp_id as $r) {
        $return[] = [
            'id' => $r['id'],
        ];
    }
}

<?php
//gid 希望从小程序返回

 $gid=$_GET['g_id'];

    $return = [];
    $rt = \Phpcmf\Service::M()->where('id in (select uid from dr_member_group_index where gid='.$gid.')')->table('member')->getAll(); // dr_改成自己的表前缀
    if ($rt) {
        foreach ($rt as $r) {
            $return[] = [
                'id' => $r['id'],
                'username' => $r['username'],
                'score' => $r['score'],
                'avatar' => $r['avatar'],//用户头像
            ];
        }
    }

'avatar' => dr_avatar($r['id']),//用户头像

大佬这样写orderby 好像错了，怎么写

<?php
//gid 希望从小程序返回

 $gid=$_GET['g_id'];

    $return = [];
    $rt = \Phpcmf\Service::M()->where('id in (select uid from dr_member_group_index  where gid='.$gid.')')->limit(10, 0)->table('member')->getAll(); // dr_改成自己的表前缀
    if ($rt) {
        foreach ($rt as $r) {
            $return[] = [
                'id' => $r['id'],
                'username' => $r['username'],
                'score' => $r['score'],
                'avatar' => dr_avatar($r['id']),
            ];
        }
    }

    $rt = \Phpcmf\Service::M()->table('member')->where('id in (select uid from dr_member_group_index  where gid='.$gid.')')->order_by('id ASC')->getAll(10); // dr_改成自己的表前缀