$moneyloglist = MoneyLog::where([‘user_id‘ => $this->auth->id]) ->where($where) ->where("FROM_UNIXTIME(createtime,‘%Y-%m‘)=‘".$time."‘") ->order(‘id desc‘) ->limit($offset, $num) ->select();
语法：FROM_UNIXTIME(unix_timestamp,format)
php mysql 按照指定年月查找数据 数据库create_time为时间戳
原文：https://www.cnblogs.com/wangziyue/p/11974822.html