public static function findByUsername($username) { $where = "username='******'"; $info = Operator::query()->where($where)->leftJoin('Role', 'Role.rid=Operator.rid')->leftJoin('Department', 'D.did=Operator.did', 'D')->leftJoin('Branch', 'B.bid=Operator.bid', 'B')->columns('Operator.oid, Operator.username, Operator.password, Role.rid, Role.name rname, D.did, D.name dname, B.bid, B.name bname')->limit(1)->execute(); if (!$info) { return null; } return $info->toArray()[0]; }