column运用

//判断情侣钱包存不存在
        $wallet = Db::table('lover_wallet')
            ->whereOr([
                'user_A' => $userId,
                'user_B' => $userId
            ])
            ->field(['id', 'user_A', 'user_B', 'all_money'])
            ->find();
        dump($wallet);

        array(4) {
          ["id"] => int(1)
          ["user_A"] => string(10) "1ZDMKxsisY"
          ["user_B"] => string(10) "eZNylMmojE"
          ["all_money"] => string(4) "0.00"
        }

 

//      两个人的头像查出来。
        $headImg = Db::table('user_data')
            ->whereIn(
                'user_id', [$wallet['user_A'], $wallet['user_B']]
            )
            ->field(['id', 'headimg', 'user_id'])
            ->column('headimg', 'user_id');

        dump($headImg);  
 

        array(2) {
          ["1ZDMKxsisY"] => string(50) "http://img.xuanhelp.com/u/201811/5bf25f47b6fdd.png"
          ["eZNylMmojE"] => string(50) "http://img.xuanhelp.com/u/201811/5bebcbbb98953.jpg"
        }

//      user_id作为键名;headimg作为值,
//      [$wallet['user_A']] == user_id;

 

 

 

转载于:https://my.oschina.net/u/4003338/blog/2998900