如何每月根据laravel中的前一行自动向数据库添加新行？

php artisan make:command AddNewRow

use App\Models\YourModel;

public function handle()
{
    // 获取前一行的数据
    $previousRow = YourModel::orderBy('created_at', 'desc')->first();

    // 创建新行并保存到数据库
    $newRow = new YourModel();
    $newRow->column1 = $previousRow->column1;
    $newRow->column2 = $previousRow->column2;
    // 设置新行的其他属性
    $newRow->save();
}

use Illuminate\Console\Scheduling\Schedule;

protected function schedule(Schedule $schedule)
{
    $schedule->command('your-command')->monthly();
}

protected $commands = [
    Commands\AddNewRow::class,
];

php artisan schedule:run