如何在URL上显示消息对话用户名，以及如何在users表中显示配置文件图片

from flask import Flask, render_template
from models import User  # 假设您有一个 User 模型

app = Flask(__name__)

@app.route('/chat/<username>')
def chat(username):
    # 从数据库中获取用户信息
    user = User.query.filter_by(username=username).first()
    if user:
        return render_template('chat.html', user=user)
    else:
        return "User not found", 404

if __name__ == '__main__':
    app.run(debug=True)

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    profile_picture = db.Column(db.String(200))  # 存储图片的 URL 或路径

    def __repr__(self):
        return f'<User {self.username}>'

<!-- user_table.html -->
<table>
    <tr>
        <th>Username</th>
        <th>Profile Picture</th>
    </tr>
    {% for user in users %}
    <tr>
        <td>{{ user.username }}</td>
        <td>
            {% if user.profile_picture %}
                <img src="{{ user.profile_picture }}" alt="{{ user.username }}'s profile picture" width="50" height="50">
            {% else %}
                <img src="default_profile_picture.png" alt="Default profile picture" width="50" height="50">
            {% endif %}
        </td>
    </tr>
    {% endfor %}
</table>

@app.route('/users')
def users():
    all_users = User.query.all()
    return render_template('user_table.html', users=all_users)