merchant_admin/app/model/MerchantUserAndBalanceModel.php

<?php

namespace app\model;

use think\Model;

class MerchantUserAndBalanceModel extends Model
{

    const merchant_user_table = 'tp_merchants_user';
    const merchant_user_balance_table = 'tp_merchants_user_balance';
    /**
     * 批量获取用户余额
     * @param $userIds
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function getMerchantUserBalance($userIds, $field = ['user_id', 'balance']) {
        $query = self::table(self::merchant_user_balance_table)->whereIn('user_id', $userIds);
        if(!empty($field)) {
            $query = $query->field($field);
        }
        return $query->select()->toArray();
    }

    /**
     * 批量获取用户信息
     * @param $userIds
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function getMerchantUser($userIds, $field = ['user_id', 'nickname'])
    {
        $query = self::table(self::merchant_user_table)->whereIn('user_id', $userIds);
        if(!empty($field)){
            $query = $query->field($field);
        }
        return $query->select()->toArray();
    }

}